Select Page

# Centida’s blog

## Business Intelligence for Financial Management applications

### Using IF Function in DAX

Watch our short and simple explanation of using the IF function in DAX. The IF function checks if a given expression is true or false, and returns one value when it’s true, otherwise it returns a second value.

### VIDEO: Using Variables in DAX

Variables can help to improve performance, readability, simplify debugging and reduce complexity of calculations.

### VIDEO: Introduction to Variables in DAX

Variables can help to improve performance, readability, simplify debugging and reduce complexity of calculations.

### VIDEO: Year-to-Date vs Running Total

In this video, we’ll continue to learn about time-intelligence functions in DAX and look at the Running Total calculation.

### VIDEO: Time-Intelligence Functions (Part 2)

In this video we’ll learn how to calculate the difference between this year and last year sales.

### VIDEO: FILTER and ALL Inside CALCULATE Function

Two common functions that you put inside CALCULATE are the ALL and FILTER functions. Watch our quick tutorial and learn how to use these functions.

### VIDEO: How to Use SumX Function in DAX

Watch our short tutorial about the use of the SUMX function in DAX.

### VIDEO: using CALCULATE function in DAX

In this video, we’ll continue learning more about DAX and will look into the function CALCULATE, which is probably one of the most important and widely used DAX formula in Power BI.

### VIDEO: Calculating Basic DAX Functions

In this video, we’ll continue learning more about DAX and will build a few different formulas.

### VIDEO: Introduction to DAX in Power BI

At the level of a business user in Power BI, you are going to use DAX in two main ways – creating calculated columns and measures.

### VIDEO: Creating the Calendar Table in Power BI

We recommend using the Calendar function: TableName = Calendar ([Start Date], [End Date]).

If you don’t know the start and end dates in your model, one solution is to use functions MIN and MAX inside the Calendar function.

### VIDEO: Cleaning and Formatting Sales Tables in Power Query

Upon importing the sales table to the Power Query editor, users can rely on functions, such as trim and format data, split columns using delimiters, change data types, filter, merge and unpivot columns and rows.

### VIDEO: Clean and Transform Financial Data in Power Query

Watch our short video to see how you can quickly transform financial data into a proper database format for further analysis.

### VIDEO: Why and When Merge Queries in Power Query

When merging tables in Power BI, you are joining them side-by-side using a matching column. Watch our video to learn the merge function.

### VIDEO: Append Multiple Excel Files From One Folder

When a new month report comes out, many still use a manual method by copying and pasting the new month data into one big Excel master file. To speed up the process and reduce manual errors and typos, Power BI’s query editor comes as an effective solution.

### VIDEO: Introduction to Variables in DAX

Variables can help to improve performance, readability, simplify debugging and reduce complexity of calculations.

### VIDEO: Year-to-Date vs Running Total

In this video, we’ll continue to learn about time-intelligence functions in DAX and look at the Running Total calculation.

### VIDEO: Time-Intelligence Functions (Part 2)

In this video we’ll learn how to calculate the difference between this year and last year sales.