topic Re: I am looking for help regarding Power BI Time Intelligence Function, mainly on LYTD. in DAX Commands and Tips

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

Sai_Kumar — Wed, 18 Aug 2021 00:35:02 GMT

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.

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

wdx223_Daniel — Fri, 13 Aug 2021 07:48:41 GMT

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

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

Sai_Kumar — Fri, 13 Aug 2021 07:57:44 GMT

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.