Forum Discussion

Matt_P's avatar
Matt_P
Helper I
7 years ago
Solved

Data Smoothing (moving average in matrix)

I have a table of data as opposite and I would like to represent it as a heat map; rows = length, columns = weight, values = qty, which ive done in excel and PBI (PBI attached).  Now I would li...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Matt_P i think this will do it, i just used -2 +2 for columns but not rows, in this updated file now it is for both. see attached. sorry for the delay :)

  • parry2k's avatar
    parry2k
    7 years ago

    Matt_P update smoothing avg total as below and rest everything should work.

     

    Smoothing Avg Total = 
SUMX(
    CROSSJOIN ( 
        ALL( FlatData[ConcSpan (bins)] ), 
        ALL( FlatData[Load (bins)] )
    ) , 
    
    [Smoothing Avg] 
)
Matt_P's avatar
Matt_P
Helper I
7 years ago

parry2k Hey, thanks for trying - doesnt provide the result im after though.  I'm getting an excel sheet together to illustrate what im after - will likely be tomorrow evening...

 

Thanks again.

parry2k's avatar
parry2k
Super User
7 years ago

Matt_P sounds good. I'm surely missing something, excel sheet will help.

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Matt_P update smoothing avg total as below and rest everything should work.

     

    Smoothing Avg Total = 
SUMX(
    CROSSJOIN ( 
        ALL( FlatData[ConcSpan (bins)] ), 
        ALL( FlatData[Load (bins)] )
    ) , 
    
    [Smoothing Avg] 
)
  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Matt_P is the data in excel sheet same what we used in smoothing report?

  • Matt_P's avatar
    Matt_P
    Helper I
    7 years ago

    Thats it - genius - absolutley fantastic - thankyou!!!

     

    On to stage 2...

    I need to do some more work to the excel to explain what im after, and I will try to repicate it in PowerBI myself first... dont hold much hope of that given past experiance.  I Just hope your still about to assist... :smileyhappy::smileyhappy:

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Matt_P glad it met the requirement. BRING IT ON :)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Matt_P  could you please provide the FlatData.xlsx again?

     

    I'd like to take a closer look into it.