Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello everyone,
Here is my problem today.
I have the measure below:
Solved! Go to Solution.
@Nick2358
You can use the time intelligence function to achieve it, try the following measure You can change the number of months as necessary, I have entered -2. If you need 14 months back,m add -14.
2020_2_Months_Ago =
CALCULATE(
SUM('Conso Bdgt 2020'[SUM]),
DATEADD(
'Dates'[Date],
-2,
MONTH
)
)
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Nick2358
You can use the time intelligence function to achieve it, try the following measure You can change the number of months as necessary, I have entered -2. If you need 14 months back,m add -14.
2020_2_Months_Ago =
CALCULATE(
SUM('Conso Bdgt 2020'[SUM]),
DATEADD(
'Dates'[Date],
-2,
MONTH
)
)
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |