Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys, I'm creating a headcount visual for new joiners. the source data that I get comes in a form of Year to date rather then Period to Date. so when I write my measure to count all the new joiners I get the following numbers, March 39, April 61, Total 100. what I want to get is 39 in march and 22 in April. = April number minus March Number, going forward it would be May number minus March number etc. is there a way to do this ?
my table looks like so: team name // FTE Alpha 5 Bravo 3 Charlie 4 Delta 5 Echo 1 Foxtrot 6 Golf 9 Hotel 17 India 4 how can I write a measure so that it sums up all the FTE's except for FTE's in teams India & Foxtrot ?
Solved! Go to Solution.
@neylamela
Try this measure:
CALCULATE( SUM ( FTE ) FILTER(TABLE, TEAMNAME IN ("India", "Foxtrot"))
@neylamela
Try this measure:
CALCULATE( SUM ( FTE ) FILTER(TABLE, TEAMNAME IN ("India", "Foxtrot"))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
109 | |
89 | |
76 | |
67 |
User | Count |
---|---|
125 | |
111 | |
100 | |
83 | |
71 |