Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi! Appreciate support from SMEs. I'm trying to calculate the measure for the certain date. I'm using CALCULATE but apparantely the FILTER function doesn't work. I tried to use both Date Table and Activity Date in the Tracker Data but none is working. What do I do wrong? See Page 2 in my report, calculation of Earliest Activity Intensity and Latest Activity Intensity.
https://drive.google.com/file/d/1wtY31hdI7_p4424GGVQUX6n4uaCNLKwL/view?usp=sharing
Solved! Go to Solution.
Hi,
Please find attached the PBI file.
Hope this helps.
@mkz81 , I think approach like this should help
Power BI: HR Analytics - Employees as on Date: https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
Hi! Thank you for sharing the videos. I have accepted the solution in the post above as it's more direct answer though videous you shared are also very useful!
User | Count |
---|---|
77 | |
74 | |
60 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |