PL-300 (Power BI): DAX functions IF, BLANK and ISBLANK.

My Microsoft Power BI Data Analyst course (PL-300) is available at rebrand.ly/da-100-power-bi
Some of my other courses are:
PL-900 Microsoft Power Platform Fundamentals: rebrand.ly/pl-900
PL-100 Microsoft Power Platform App Maker: rebrand.ly/pl100
PL-200 Microsoft Power Platform Functional Consultant: rebrand.ly/PL-200
PL-400 Power Platform Developer: rebrand.ly/PL-400
Details of other courses are available at www.idodata.com
---
This course teaches the requirements for the Microsoft Certificate PL-300 "Power BI Data Analyst". In the course, we'll be looking at:
Prepare the data (using Power Query and the M language),
Model the data (using the DAX language),
Visualize and analyze the data, and
Deploy and maintain assets.
---
In this video, we will look at a sample video of my PL-300 course, looking at the DAX functions IF, BLANK and ISBLANK.

[@erinfield1943]

Starts at 1:33
1:44- IF()
3:18- IF() + 1
4:20- where he deals with misleading zeros
6:50- using BLANK() to get blanks instead of false totals (to get around string/number constraints)
7:45- using ISBLANK() to distinguish between 0 and actual blanks
8:28- final DAX formula

[@shaygooding]

Omg this helped me so much thank you! Could not find the solution anywhere else!

[@IDoData]

Hi Shay. Thank you very much. I hope that you'll join me for the full course. Phillip

[@Drewow]

Hey Phillip, do you have any plans on working on a course in relation to the new dp-500 exam that microsoft released? Finished your dp 900 and currently doing the dp 300 and pl 300 next!

[@IDoData]

Hi Andres. The DP-500 is on my short-list, but won't be anytime soon. Phillip

[@Drewow]

@@IDoData Looking forward to it!

[@nycollassilva3558]

@@IDoData fdhjbbhqvh