Forum Discussion
How to display Measure for certain Date
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
Hi,
Please find attached the PBI file.
Hope this helps.
3 Replies
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-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZUHi! 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!
Hi,
Please find attached the PBI file.
Hope this helps.
