Forum Discussion
Solved
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...
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
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