Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have a DATEDIFF calculated column that's returning incorrect values for all rows whose Review Due is past the current date:
Days Due =
SWITCH(
TRUE(),
'Data'[Review Date] = BLANK(), BLANK(),
'Data'[Review Due] <= TODAY(), 0,
DATEDIFF('Data'[Review Date], 'Data'[Review Due], DAY)
)
E: My bad, it was computing properly 😂
Hi, @olimilo
it seems correct
can you elaborate detailed problem where you stuck?
I just realized I was supposed to use the current date instead of the Review Date. My bad 😂