Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
AlexisPREVOT
Helper III
Helper III

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 :
AlexisPREVOT_0-1617775389385.png

 

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

Thanks in advance

 

 Alexis
1 ACCEPTED SOLUTION
AlexisPREVOT
Helper III
Helper III

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

 

 

View solution in original post

5 REPLIES 5
AlexisPREVOT
Helper III
Helper III

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
Helper III
Helper III

Thank you for yours answers.

 

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

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.

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


Go to My LinkedIn Page


selimovd
Super User
Super User

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
 
Jihwan_Kim
Super User
Super User

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.

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


Go to My LinkedIn Page


Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.