Tutorial with example
In today’s video we will go through the DAX functions of MAX, MAXX and MAXA.
Download example file:
When evaluating a single column that contains numeric values, if the column contains no numbers, MAX returns a blank. If you want to evaluate values that are not numbers, use the MAXA function.
When comparing two expressions, blank is treated as 0 when comparing. That is, Max(1, Blank() ) returns 1, and Max( -1, Blank() ) returns 0. If both arguments are blank, MAX returns a blank. If either expression returns a value which is not allowed, MAX returns an error.
Example2: Get previous row in DAX
You have been asking me, how do I calculate previous row in Power BI using DAX so I can get new cases on the corona dataset? , and this is exactly what we are going to do in this video.
Table of contents:
00:50 Append all cases type in one column
03:00 Change the financial times calculation for the new column
04:00 Calculate previous row using dax
Watch the tutorial:
Links to the mentioned resources
To get the file:
1. Go to Curbal Download Center > DAX Fridays
2. Get File #167
Hope we have the downloadable power bi file available as well : )
Ruth Pozuelo Martinez
No file available I am afraid, but you can use any of the other files to try the functions 🙂