LLY and LLLY DAX

[prasy14]

Hello All,

i am trying to calculate total sales amount for each week,Month,Qtr.

I have calendar table and i have created a heirarchy Year,Season,Quarter,Month,Week( 2 seasons per year).

What i want to display in reports is total amount of sales by period for current Year, Previous Year(LY), previous Previous Year(LLY),Previous Previous Previous year(LLLY) ( by Heirarchy on Matrix table)

TSales =
CALCULATE(SUM('sales'[sales_amt]),'bi_calendar'[bi_date], bi_calendar[IsInCurrentYear]=1)

LLY Sales =
CALCULATE(SUM('sales'[sales_amt]),SAMEPERIODLASTYEAR(SAMEPERIODLASTYEAR('bcalendar'[bdate].[Date]))

[Anonymous]

Hi all! 

I'm trying to get the sales value of the previous previous month but i'm not been able to reach it using parallelperiod formula. 

(CALCULATE(Consolidado[TO]; PARALLELPERIOD(Consolidado[Fecha creacion];-2;MONTH)));0))

Now we are working in March, so I must get January value.

Thanks

[v-caliao-msft · Accepted solution]

@prasy14,

You could use PARALLELPERIOD function which returns a table that contains a column of dates that represents a period parallel to the dates in the specified dates column, in the current context, with the dates shifted a number of intervals either forward in time or back in time.

Sample DAX.

=CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), PARALLELPERIOD(DateTime[DateKey],-2,year))  

Regards,

Charlie Liao