Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Week over Week Qty Change = VAR lastWeekAmount = CALCULATE ( SUM ( Merge1[Qty To Return

Hello Communit  -   My source data has zeros  (not blanks) but I am still getting the output in my matrix table (below).       How can I clean this up to where the blanks show as 0% instead?    Als...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello, 

 

I realized my error...actually the two formulas are computing different things.   One is week over week change, the other is each week's prior sales.    When I converted that column to a whole number, it made sense.  

 

However....there is one very strange thing happening which I cannot make sense of.     All of the week to week percents make sense, until you get to the 1764.15% row.      For example, a change from 68 to 79 is indeed 16.18%.     17 to 87 is a 411% change, etc.  

 

But a change from 79 to 1976 should be 2401%.   Not 1764%.    I really can't figure out why that one number would be calculating incorrectly and different from all of the others?  

 

 

 

 

 

 

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

This kind of behavior usually suggests you have duplicate row error in your SUMX (or other iterator).  Or one of them is iterating over week granularity and the other is not (similar to total row errors).

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat