How to display Measure for certain Date

[mkz81]

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 

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached the PBI file.

Hope this helps.

[amitchandak]

@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

[mkz81]

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!