time intelligence power bi date functions not working with measures as arguments

Question

I have a table TNS_dati with sales volumes [Cena Euro] and date column [Datums / Periods] and related calendar table "calender" as date table. I am trying to calculate sales for all the period except the last month and found very tricky thing :&nbsp;1. when I am harcoding the date :&nbsp;Vecie klienti = CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM(TNS_dati[Cena EURO]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Calender,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;// &nbsp; TNS_dati[Datums / Periods] &lt; DATE(YEAR(max(TNS_dati[Datums / Periods])),3,1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Calender[Date] &lt; date(2023, 2,29)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // &nbsp;DATESBETWEEN(TNS_dati[Datums / Periods], blank(), max(TNS_dati[Datums / Periods])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // &nbsp;DATESINPERIOD(Calender[Date], min(Calender[Date]),13,MONTH)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )It works perfectly and returns what I am looking for, but when I am using a measure (for instance for year =&nbsp;&nbsp;YEAR(max(Calender[Date])), It returns for 2023 ok but for all the previous years only Jan, Feb.&nbsp;Could someone explain why it is so and how to solve it?&nbsp;&nbsp;&nbsp;

viesturs · Accepted Answer

Solved by myself.&nbsp;

Forum Discussion

time intelligence power bi date functions not working with measures as arguments

1 Reply

Related content

Dax Time Intelligence Functions Weird behavior - 13 Month Rolling Calc

Table.Sort, unexplainable behaviour with a two-argument function

Send Argument

Custom function Expression Error: 1 argument passsed which expects 2 arguments.

Help with Date intelligence