Forum Discussion
Filter Historical Data
Unknowncharacte , You have to use cross filter to remove the join
refer, blog video, or attached files after signature
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/fvgcx8QLqZU
I did this measure, but it's counting cases that were opened in that quarter, I assume because I have a direct connection from fact table to dim calendar. How do I count all "active" cases?
Open Cases = COUNTROWS( FILTER( ALL('Fact Table'), [DateOpened] <= MAX('DIM Calendar'[Full Date]) && [DateClosed] >= MAX('DIM Calendar'[Full Date]) ) )