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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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])
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 12 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 31 | |
| 28 | |
| 19 | |
| 11 | |
| 10 |