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

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:

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.