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 displayed in the associated column.

 

My formula : 

TotalPREC = CALCULATE(SUM(LIGNES_FACT[LFC_FACTURE_CONSOLIDEE]),SAMEPERIODLASTYEAR(FACTURES[FCC_DATE]))
 
And the visualization :

 

Can you please explain to me why this is not working ?

Thanks in advance

 

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

     

     

5 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey AlexisPREVOT ,

     

    do you have a proper date dimensional table where each day in the desired time area (including weekends) appears once?

    If that is the case did you mark it as data table?

    If that is not the case try to add an ALL in you calculation:

    TotalPREC =
CALCULATE(
    SUM( LIGNES_FACT[LFC_FACTURE_CONSOLIDEE] ),
    SAMEPERIODLASTYEAR( FACTURES[FCC_DATE] ),
    ALL( FACTURES[FCC_DATE] )
)

     

    All of the time intelligence functions only work with a proper date table.

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
  • AlexisPREVOT's avatar
    AlexisPREVOT
    Resolver I
    5 years ago

    Thank you for yours answers.

     

    I do have a clean date table.
    But unfortunately no solution works, I have the same result each time ...

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      5 years ago

      Hi,

      Thank you for your feedback.

      If it is OK with you, please share your sample pbix file's link, then I can try to look into it to find a way.

       

      Thank you.

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