Forum Discussion
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...
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])
)
)
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.