I am looking for help regarding Power BI Time Intelligence Function, mainly on LYTD.

[Sai_Kumar]

Hello everyone,

I am looking for help regarding Power BI Time Intelligence Function on LYTD.

I had YTD, LYTD sales figures. But, the Current LYTD function was providing all the sales for last year. (I am looking for something that LYTD needs to give the data up to the same period the previous year)

Sales LYTD = CALCULATE([SalesAUD],DATEADD('Master Calendar'[Date],-1,YEAR))
And

Sales AUD is the total sales.

I want to stop the FY22 LYTD sales data, which are across the current month.

Thanks.

[wdx223_Daniel]

Sales LYTD = if([SalesAUD],CALCULATE([SalesAUD],DATEADD('Master Calendar'[Date],-1,YEAR)))

[Sai_Kumar]

Hey, Thanks for sharing the knowledge.

It seems like working, what I am looking for. But, Why the total was getting total sales amount for last year instead of summing only those months sales.