Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I need to create a visualisation to show roles that are due to finish each month on a project. I have the end dates in a cloumn named [Role Finish Date] along with other information such as [Name] [Project] [Role] [Function] etc so i should be able to create a graph to show how many roles are ending each month but for some reason it is getting the better of me.
This is what i have tried so far but it is returning some funky visuals that are way off:
Count of ending roles =
VAR currentDate =
MAX('Date Table'[Date])
RETURN
CALCULATE(
COUNTROWS(TTracker),
FILTER(
TTracker,
(TTracker[Role Start Date <= currentDate && TTracker[Role Finish Date] >= currentDate)
)
)
Any advice on creating this visual would be gratly appreciated
Create a relationship from the date table to the role finish date, make it inactive if necessary, and then you can use
Num ending rows =
CALCULATE (
COUNTROWS ( 'TTracker' ),
USERELATIONSHIP ( 'Date'[Date], 'TTracker'[Role finish date] )
)
If you can make the relationship active then you would only need COUNTROWS('TTracker')
User | Count |
---|---|
98 | |
90 | |
83 | |
69 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |