Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
So im trying to get the previous month HC data per month, but i keep on missing December as seen below. All the other months align perfectly, am i missing something?
I have a measure setup -
Solved! Go to Solution.
Hi @Lobs ,
Try to use date table in the dateadd.
Previous Month HC =
CALCULATE (
SUM ( 'Retention Local 2'[HC_Cur_Mo] ),
DATEADD ( 'calender_table'[date], -1, MONTH )
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Lobs ,
Try to use date table in the dateadd.
Previous Month HC =
CALCULATE (
SUM ( 'Retention Local 2'[HC_Cur_Mo] ),
DATEADD ( 'calender_table'[date], -1, MONTH )
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
thank you this worked, just linked my calendar and updated the views, all good now
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |