Forum Discussion

AlexisPREVOT's avatar
AlexisPREVOT
Resolver I
5 years ago
Solved

Sameperiod Last Year - Display Issue

Hi the community,   Like many of you, I try to compare billing amounts from year to year. I used the "sameperiodlastyear" function but even if the calculation looks good, the values ​​are not disp...
Need Help
  • AlexisPREVOT's avatar
    AlexisPREVOT
    5 years ago

    Hi,

    Hello,

    Thank you again for your answers.
    By digging into the idea of ​​filtering, I found a solution on the Internet in 2 steps:
    1 calculated column : LastYear = DATEADD(Calendar[Date];-1;year)

     

    and 1 measure : CALCULATE(
    SUM(LIGNES_FACT[LFC_FACTURE_CONSOLIDEE]);
    FILTER(
    All(Calendar);
    CONTAINS(VALUES(Calendar[Last Year]);Calendar[Last Year];Calendar[Date])
    )
    )

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, AlexisPREVOT 

Please correct me if I wrongly understand your question.

I think there are some limitations in using sameperiodlastyear.

 

https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

 

Instead, please try to use DATEADD  DAX function.

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.