Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a table with a number by person by date. I want to calculate the average for current month/month(s) previous.
I've tried 2 calculations, neither work:
Understand the preference is to provide a pbix file. I unfortunately am not able to do that. Appreciate any help anyone is willing to provide without pbix files. I am very close to getting to what I need, but am missing something small I think..
Solved! Go to Solution.
@kressb - Are these calculated columns or measures? Look like calculated columns. Try:
Average#MTD= AVERAGEX(Filter(Table,Table[Date].[Date]<=EARLIER(Table[Date].[Date] && [Name]=EARLIER(Table[Name])),Table[Number])
@kressb - Are these calculated columns or measures? Look like calculated columns. Try:
Average#MTD= AVERAGEX(Filter(Table,Table[Date].[Date]<=EARLIER(Table[Date].[Date] && [Name]=EARLIER(Table[Name])),Table[Number])
Yepp! That did it - THANK YOU very much for the help!
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |