Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Guys ! I am using this formula in Power query but it showing only else value
if [Date Closed]="null" and [Critical Defect]0 then 1 else 0
Solved! Go to Solution.
if [Date Closed] is null and [Critical Defect] = 0 then 1 else 0
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
if [Date Closed] is null and [Critical Defect] = 0 then 1 else 0
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Thankyou so much but why = was not working and please adivse the if formula for date Column.thanks
Perhaps the contents of the cell is actually null and not a string containing null. Try removing the quote marks around null.