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.
I am looking for help with my DAX formula to show if Install Date > Ship Date then flag it as a 1 otherwise 0. Currently, I am using the formula below but I don't want it to calculate for products with no ship dates.
Past Due Flag = IF('IV_Product'[Install Date] > 'IV_Product'[Ship Date], 1, 0)
Solved! Go to Solution.
Try this @rachaelwalker
Past Due Flag =
IF(
ISBLANK( 'IV_Product'[Ship Date] ),
BLANK,
IF(
'IV_Product'[Install Date] > 'IV_Product'[Ship Date],
1,
0
)
)
If ShipDate is blank, it returns blank, otherwise it does your normal 1/0 result.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingJust a small thing you missed is that you didn't add parenthesis after BLANK. It Should be BLANK().
Everything else is correct.
Try this @rachaelwalker
Past Due Flag =
IF(
ISBLANK( 'IV_Product'[Ship Date] ),
BLANK,
IF(
'IV_Product'[Install Date] > 'IV_Product'[Ship Date],
1,
0
)
)
If ShipDate is blank, it returns blank, otherwise it does your normal 1/0 result.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingJust a small thing you missed is that you didn't add parenthesis after BLANK. It Should be BLANK().
Everything else is correct.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
37 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
32 | |
28 | |
24 | |
24 |