Forum Discussion

khat's avatar
khat
Regular Visitor
3 years ago

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...
Need Help
khat's avatar
khat
Regular Visitor
3 years ago

Greg_Deckler 

Thank you. I followed the link and watched the video as well. Learned a lot but it's still a bit advanced for me. Below is my attempt at using that measure and replacing it with my own tables, which did not work. Any tips on where I went wrong?

 

Thanks again for the video, I appreciated your explanation of VAR, which was new to me.

 

 

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

khat What does "See details" say?

  • khat's avatar
    khat
    Regular Visitor
    3 years ago

    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

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      3 years ago

      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.