Forum Discussion

JEM_Systems's avatar
JEM_Systems
Icon for Helper I rankHelper I
3 years ago
Solved

function SAMEPERIODLASTYEAR() not working

Hi, I'm trying to apply a sameperiolastyear function but is not working, this is my DAX:  Invoices Same Period Last Year =    CALCULATE(     SUM('Monthly Sales Evolution Invoices'[Sum of ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi JEM_Systems ,

     

    I suggest you to create a calendar table with continuous date by CALENDAR()/CALENDARAUTO() function.

    Calendar = ADDCOLUMNS(CALENDARAUTO(),"Year",YEAR([Date]))

    Measure:

    LY Sales = CALCULATE(SUM('Table'[Sales]),SAMEPERIODLASTYEAR('Calendar'[Date]))

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

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

     

     

JEM_Systems's avatar
JEM_Systems
Icon for Helper I rankHelper I
3 years ago

Is not showing any data, could you RMDNA help me?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi JEM_Systems ,

 

I suggest you to create a calendar table with continuous date by CALENDAR()/CALENDARAUTO() function.

Calendar = ADDCOLUMNS(CALENDARAUTO(),"Year",YEAR([Date]))

Measure:

LY Sales = CALCULATE(SUM('Table'[Sales]),SAMEPERIODLASTYEAR('Calendar'[Date]))

Result is as below.

 

Best Regards,
Rico Zhou

 

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