Last year calculations

[Anonymous]

Hi guys,

I am stucking on last year same period calculations.

like we are in 2021 so this year calculation period will be-  1st jan21 to 3rd oct 2021

and Last year same period will be 1st Jan20-3rd Oct2020- how can I get this result

I have tried- calculate(sum(sales),sameperiodlastyear(date[date])- showing incorrect result.

Please help me on this.

@Tanushree_Kapse @amitchandak 

[VahidDM]

Hi @Anonymous 

Try this:

Measure=
Var _T = Today()
Var _LYS = date(year(_T)-1,01,01)
Var _LYF = date(year(_T)-1,month(_T)+1,01)-1
Return
calculate(sum(sales),filter(table,date[date]>=_LYS &&date[date]<=_LYF ))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[Anonymous]

Thanks,

It is giving jan20-Oct20 data but I am trying to find out 1st Jan20-3rd Oct 20.

only we have to rectrict the date range.

[VahidDM · Accepted solution]

Hi @Anonymous 

Try this:

Measure=
Var _T = Today()
Var _LYS = date(year(_T)-1,01,01)
Var _LYF = date(year(_T)-1,month(_T),day(_T))
Return
calculate(sum(sales),filter(table,date[date]>=_LYS &&date[date]<=_LYF ))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[Anonymous]

@VahidDM 

Thanks. Now got my anser what I was looking for.

Great Salute :).

[Fowmy]

@Anonymous 

Your formula seems okay, make sure in your date slicer you have selected 1st jan21 to 3rd oct 2021

Measure = CALCULATE ( SUM ( sales[column] ), SAMEPERIODLASTYEAR ( date[date] ) )

[Anonymous]

Hi,

Thanks for quick reply.

Actually I dnot want to select any date slice point. have to show in formala.

Request you to please reshare formula please.

Thanks

[Tanushree_Kapse]

Hi @Anonymous ,

Try thi measure:
Lastperiod=  Calculate(Totalytd(Sum(sales),date[date]) ,Parallelperiod(date[date], -12, Month))

Mark this as a solution if I answered your question. Kudos are always appreciated.
Thanks

[Anonymous]

Hi,

Thanks for quick reply

But This formula is not showing correct result as trying to match manual.

Request you can you please check once nd reply please

Thanks

[Tanushree_Kapse]

Hi @Anonymous ,

Can you try this:

YTDSales= TOTALYTD(SUM(Sales), DATESYTD(date[date], TODAY()))
PYTDSles= CALCULATE(YTDSales, DATESYTD(date[date], TODAY()-1))

Thanks