Curbal shows you how to write if-statements like a pro.


  • 00:40 if stamentent in Excel wont work
  • 01:50 Use power query user interface to write if statement
  • 03:00 Nested if-statements
  • 03:38 AND/OR conditions in if statements
  • 04:48 NOT condtition in if statements
  • 05:20 Manage errors in if statements
  • 06:13 Advanced if statements
  • 08:19 Order of evaluation if statements

Curbal shows you how to unpivot tables with DAX. (whether or not you should do it in DAX may be a different question)

She then unpivots them using Power Query so you can see the difference, and how Power Query can be faster and more efficient for cleaning data.