Forum Discussion
Solved
Dividing the Subtotal without changing Values in Matrix
I'm trying to create a Power BI Measure that calculates an Average based on the amount of years (We use a relative date for the past 5 years, so the average should just be the sum of the row, divided...
Hi,
PBI file attached.
Hope this helps.
Hey Ashish,
Thanks so much! Those values seem to work on your provided file, but I can't seem to replicate it. How did you accomplish this?
I've created the Table named Calendar and added the 'Year' calculation, as well as changing the Measure code, but mine comes out like this:
You are welcome. Create a relationship (Many to One and Single) from the Resignation date column to the Date column of the Calendar table.
You're a legend! I've been stuck on this for 2 days.
That looks to be working now 🙂
You are welcome. Thank you for your kind words.