DateDiff Issue in Calculated Column

[yashwant101]

Hi all,

I have 2 tables. One is the date universe and the other has multiple date columns for the data. If I put slicer of the date universe and apply datediff for individual columns with max date in date universe. It is calculating incorectly. 

Description: I have 2 tables- Calendar & DataDate.

I have put a date slicer from Calendar table. The Max Date measure is calculated as below:

Max Date = MAX('Calendar'[Date])

It should respond to the slicer. Working as expected.

I have created a Date Diff column in DataDate table as below:

Date Diff = DATEDIFF(DataDate[DiffDate].[Date], [Max Date],DAY)

It should give the daysdiff between max date selected in slicer and individual dates. Here is where the issue begins. The Date Diff column is not being affected by the slicer. It us taking difference between individual dates in DataDate table and max date in Calendar table. 

Please help me with thus issue. Any help is appreciated.

Regards,

Yashwant

[Uzi2019]

Hi @yashwant101 
Please try the below measure:
Measure= 

DATEDIFF(Min(DataDate[DiffDate]),Max(Calendar[date],day)

Dont create seperate measure for Max of date. you have taken column for calculation when its is numeric calculation try to avoid calculated columns.

If my post helps please give kudos and accept it as a solution!
thanks