leap year correction

Question

Hi,&nbsp;&nbsp;I have made measures that show last 12 and 24 months (rolling 12 month/24 months),&nbsp;When I select year 2020 I get a wrong value for February.&nbsp;case sales:2019 value 28th feb = 20year&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;last 12 month&nbsp; &nbsp;last 24 month2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(2019)feb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4028th&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2029th&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20There is an extra line for the 29th day in feb-2020 and this get the same value as 28th feb 2019. How can I correct for the leap year error?N is number of months&nbsp;Salgsinntekt forrige N mnd = var Ldato = DATE(MAX('Year'[year]);MAX(Mnd[order])+1;1)var Fdato = EDATE(Ldato;-(MAX(N[N])))var Sales = CALCULATE([Sales];SAMEPERIODLASTYEAR(Calendar[date]))returnif(min(Calender[date])&lt;Fdato;&nbsp; &nbsp; &nbsp; &nbsp;blank();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if(min(Calender[date])&gt;=Ldato;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blank();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sales)

icey · Answer

Hi&nbsp;Anonymous ,
&nbsp;
I'm not very clear about your requirements. Can you give me more information?
&nbsp;
&nbsp;
Best Regards,
Icey

Forum Discussion

leap year correction

1 Reply

Related content

SamePeriodLastYear and Leap Year?

Sameperiodlastyear - Leap Year

DAX and leap year, date range

Managing leap year comparisons

Leap year week number