Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Last year calculations

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 

DAX Calculation
SAME PERIOD LAST YEAR
  • VahidDM's avatar
    VahidDM
    4 years ago

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

     

9 Replies

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        Tanushree_Kapse
        Icon for Impactful Individual rankImpactful Individual
        4 years ago

        Hi Anonymous ,

        Can you try this:

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

         

        Thanks

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        VahidDM
        Icon for Super User rankSuper User
        4 years ago

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