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

     

     

AlexisPREVOT's avatar
AlexisPREVOT
Resolver I
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])
)
)