I need to count the number of accumulated contracts (formula below) per month. Then I need the same calculation to compare with the last year.
At this point is when I can not continue. I don't know where or how use SAMEPERIODLASTYEAR.
The Fact table is "ContratosServicio" and the Calender table "Calendario".
Go to Solution.
Hi @joaquinel ,
I think you have to use this measure
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.