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.
I am trying to make a cumulative sum column that calculates the cumulative sum based off of an employees name, and the year. So Alice and Bob may have values for 2020 and 2021 that I would like to calculate seperately. Right now my formula is
TotalByMonth running total in Period|Year|Director =
CALCULATE(
SUM('Table'[TotalByMonth]),
FILTER(
ALLSELECTED('Table'[Year|Employee], 'Table'[Employee], 'Table'[Year]),
ISONORAFTER('Table'[Year|Director], MAX('Table'[Year|Employee]), DESC)
)
)
But the issue I am having is that slicers do not seem to impact the year, only the Employee name.
Solved! Go to Solution.
@AM_VRSResearch , Based on what I got
Try like
CALCULATE(
SUM('Table'[TotalByMonth]),
FILTER(
ALLSELECTED('Table'[Year|Employee], 'Table'[Employee], 'Table'[Year]),
ISONORAFTER('Table'[Year|Director], MAX('Table'[Year|Employee]), DESC) && 'Table'[Employee] =max('Table'[Employee])
)
)
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@AM_VRSResearch , Based on what I got
Try like
CALCULATE(
SUM('Table'[TotalByMonth]),
FILTER(
ALLSELECTED('Table'[Year|Employee], 'Table'[Employee], 'Table'[Year]),
ISONORAFTER('Table'[Year|Director], MAX('Table'[Year|Employee]), DESC) && 'Table'[Employee] =max('Table'[Employee])
)
)
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
This was the answer I was looking for. Thank you.
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |