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.
Morning all!
I'm really stuck on this one so any help would be amazing!
I'm looking at a list of employees with various start and end dates over a rolling 12 months.
The employee data has anyone who started prior to the 12 months and anyone who ended from 12 months ago up until today.
What I'm trying to do is filter to any date in the past 12 months and see the head count at that date.
Is this possible?
Solved! Go to Solution.
hi, @m1ke909
Yes, you could get it. here is the similar post, you could refer to it:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Best Regards,
Lin
Hi,
Share some data and show the expected result.
hi, @m1ke909
Yes, you could get it. here is the similar post, you could refer to it:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Best Regards,
Lin
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |