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.
Hi Mates,
When I am trying to use the DATEDIFF function in the new column in a selected table then I am getting a value of 44778.
DAX Function in the column is:
Case3 = IF( 2021 <> 2022 && 2022 = 2022 ,DATEDIFF(Sheet1[STARTofYR],TODAY(),DAY), 0)
Quick Measures
[STARTofYR] = DATE(Sheet1[Selected Year],01,01)
[Selected Year] = SELECTEDVALUE(Calender[Date].[Year])
I am getting a value of 44778.
Can someone help me with the problem?
Thank You for the help in advange.
Solved! Go to Solution.
Hi, @Akash18
Calling measure in a calculated column is not recommended.
Please convert 'Case3' into a new measure and display its result in a card/table visual.
Best Regards,
Community Support Team _ Eason
Hi, @Akash18
Calling measure in a calculated column is not recommended.
Please convert 'Case3' into a new measure and display its result in a card/table visual.
Best Regards,
Community Support Team _ Eason
Yes.
Hi!
Do you display values of this measures?
[STARTofYR] = DATE(Sheet1[Selected Year],01,01)
[Selected Year] = SELECTEDVALUE(Calender[Date].[Year])