Forum Discussion
7-day Rolling Average help
Hello, I am struggling with replicating a 7-day rolling average in Power BI that I can easily do in Excel. I'm new to Power BI and am struggling with search terms so this is probably a simple questio...
khat What does "See details" say?
Hi Greg_Deckler
Here is the text (image below):
Error Message:
MdxScript(Model) (13, 28) Calculation error in measure 'DateInspected'[Better Rolling Average]: The function SUM cannot work with values of type String.
I chose the DateInspection(ProductDisposition.Type) table because that is what I need counted and it was what I thought most closely matched your example, should I have used the Daily Scrap Count measure instead?
Thank you again for your help
khat You either need to change your Type column to a number or use a different aggregator like COUNT. Your Type column is Text right now so you can't SUM a Text column.