topic Re: Last year calculations in DAX Commands and Tips

Last year calculations

Anonymous — Sun, 03 Oct 2021 06:06:26 GMT

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

Re: Last year calculations

Tanushree_Kapse — Sun, 03 Oct 2021 06:11:47 GMT

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

Re: Last year calculations

Fowmy — Sun, 03 Oct 2021 07:27:52 GMT

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] ) )

Re: Last year calculations

Anonymous — Sun, 03 Oct 2021 11:51:23 GMT

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

Re: Last year calculations

Anonymous — Sun, 03 Oct 2021 11:52:33 GMT

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

Re: Last year calculations

VahidDM — Sun, 03 Oct 2021 11:57:08 GMT

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!!

Re: Last year calculations

Tanushree_Kapse — Sun, 03 Oct 2021 12:06:46 GMT

Hi Anonymous ,

Can you try this:

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

Thanks

Re: Last year calculations

Anonymous — Sun, 03 Oct 2021 12:24:02 GMT

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.

Re: Last year calculations

VahidDM — Sun, 03 Oct 2021 12:31:29 GMT

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!!

Re: Last year calculations

Anonymous — Sun, 03 Oct 2021 12:54:41 GMT

VahidDM

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

Great Salute :).