Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |