First DAX attempt not working - 12m back.

CityZ3n — Fri, 21 Apr 2023 01:58:31 GMT

I'm trying to create a visualisation that goes back 12 months from the selected date in a slicer.

I'm working off this video - https://www.youtube.com/watch?v=d8Rm7dwM6gc

My Code so far is:

TRI P12M = VAR ReferenceDate = MAX ( 'Date'[Date] ) VAR PreviousDates = DATESINPERIOD ( 'Previous Date'[Date], ReferenceDate, -12, MONTH ) VAR Result = CALCULATE( MAX( 'DataFreqRates'[TRI Month]), PreviousDates, USERELATIONSHIP ( 'Date'[Date], 'Previous Date'[Date]) ) RETURN Result

I can follow what the video is saying and what it is trying to do, but I am getting an error - MdxScript(Model) (18, 5) Calculation error in measure 'DataFreqRates'[TRI P12M]: an invalid numeric representation of a date value was encountered.

Which I think is saying I am trying to sum a date, but I'm not sure how or why.

Suspect its cause I'm only new to DAX and am missing something basic.

More Info -
TRI Month is basically a performance metric for the end of the month.
DataFreqRates is the table that calculates several scores.

Can someone point me in the right direction?

topic First DAX attempt not working - 12m back. in DAX Commands and Tips

First DAX attempt not working - 12m back.