cancel
Showing results for
Did you mean:
Regular Visitor

## Running Total - how to fill blank values

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Running Total - how to fill blank values

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:

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team

## Re: Running Total - how to fill blank values

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:

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

## Re: Running Total - how to fill blank values

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