Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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])
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |