Running Total - how to fill blank values

[naivecalf]

Hi,

I did a running total base on YY-MM-RCVD， but there are some of blanks since there are no data on the month, is there a way to show last cell data.

EX, first column, 201807 to 201808, I just want 201808 to show 1.15%.

Regards

Steven

[v-lili6-msft · Accepted solution]

hi, @naivecalf 

You could try this simple way:

Step1:

Add a complete fact YY-MM-RCVD table, then create the relationship with "LM RMA LIST" table,

Step2:

For matrix visual, drag "YY-MM-RCVD" from YY-MM-RCVD table instead of "LM RMA LIST" table.

Step3:

Adjust measure:

measure= 

CALCULATE( SUM("LM RMA LIST" [YY-MM-RCVD]), Filter(ALL("YY-MM-RCVD"), "YY-MM-RCVD"[YY-MM-Rcvd]<=max("YY-MM-RCVD"[YY-MM-Rcvd]) ) )

Best Regards,

Lin

[naivecalf]

@v-lili6-msft, thanks a lot, this is great.