Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi,
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".
Solved! Go to Solution.
Hi @joaquinel ,
I think you have to use this measure
CALCULATE(
[15_TotalBOPLastPeriod],
SAMEPERIODLASTYEAR('calendario'[date])
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @joaquinel ,
I think you have to use this measure
CALCULATE(
[15_TotalBOPLastPeriod],
SAMEPERIODLASTYEAR('calendario'[date])
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Great!!!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.