Emplyee operation level by start & End

[Anonymous]

Hi i will report opertion level by Employee on Start and Date date. 

if Selectedmoth = November 

A   o1

C  o3

D  o3

if Selectedmoth = September

A   o1

C  o3

D  o1

any Idee? 

[v-rzhou-msft · Accepted solution]

Hi @Anonymous ,

I suggest you to add an unrelated date table and then create a measure to filter your visual.

Measure = 
VAR _SELECTSTART = MIN('Calendar'[Date])
VAR _SELECTEND = MAX('Calendar'[Date])
RETURN
IF(MAX('Table'[Range start])<=_SELECTEND && OR(MAX('Table'[Range end]) > _SELECTSTART, MAX('Table'[Range end]) = BLANK()),1,0)

Add this measure into visual level filter and set it to show items when value = 1.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.