Forum Discussion
easton16
4 years agoFrequent Visitor
Glide path using from to date in data
Good Evening All, A simple one I am hoping but going around in Circles at present. I am making a glide path to show total number of active items each period (have date look up table for perio...
- Anonymous4 years ago
Hi easton16 ,
You can refer the content in the following links to get it.
Measure to count active employees in a period based on Slicer Calendar
Count of Active Users In date range
Calculate OPEN CASES over time in Power BI
1. Have a date dimension table first
2. Create a measure as below
Employee Count = VAR __DATE = MAX ( 'Date'[Date] ) RETURN SUMX ( EmployeeTable, IF ( EmployeeTable[DateStarted] <= __DATE && OR ( EmployeeTable[Leavedates] >= __DATE , ISBLANK(EmployeeTable[Leavedates]) ), 1, BLANK () ) )3. Create visual
Best Regards
amitchandak
4 years agoSuper User
easton16 , This blog and the attached file should help. Current employee you are looking for