Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
FreemanZ
Super User

Hi spandy34 ,

 

try to plot a visual with Month column and a measure like:

 

measure =
CALCULATE(
    DISTINCTCOUNT(data[LinkID]),
    FORMAT(data[end date in role], "mmm-yy") = MAX(data[month])
)

 

 

it worked like: