Power BI: using IF statement
In Power BI you can write the IF function in two different ways: in columns and measures.
When you need to introduce more than two conditions, you have to use the nesting IF statements.
Since measures aren’t the rows in a table and the IF statement needs rows to operate, you have to create a row context. One way to do that is by using the iterator functions, like SUMX, and then putting the IF statement inside that function.
Download sample file: https://bit.ly/31lsjQ8
To learn more about Power BI and DAX formulas, follow us on social media: / centida
#PowerBI #DAX #IF #tutorial