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.
Centida’s blog
Business Intelligence for Financial Management applications
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.
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
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.