topic Re: Issue related to DAX function when creating a new column in a selected table in DAX Commands and Tips

Issue related to DAX function when creating a new column in a selected table

Akash18 — Sun, 07 Aug 2022 11:34:17 GMT

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.

Re: Issue related to DAX function when creating a new column in a selected table

technolog — Sun, 07 Aug 2022 12:34:17 GMT

Hi!

Do you display values of this measures?

[STARTofYR] = DATE(Sheet1[Selected Year],01,01)

[Selected Year] = SELECTEDVALUE(Calender[Date].[Year])

Re: Issue related to DAX function when creating a new column in a selected table

Akash18 — Sun, 07 Aug 2022 14:47:07 GMT

Yes.

Re: Issue related to DAX function when creating a new column in a selected table

v-easonf-msft — Tue, 23 Aug 2022 09:17:04 GMT

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