cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
naivecalf Regular Visitor
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%.

Clipboard01.jpg

 

Regards

Steven

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
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:

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

 

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
Highlighted
Community Support Team
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:

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

 

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.
naivecalf Regular Visitor
Regular Visitor

Re: Running Total - how to fill blank values

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