Forum Discussion

sajal161292's avatar
sajal161292
Icon for Helper V rankHelper V
8 years ago

To calculate the total dynamically

Hi,   I am stuck up in calculating a running total for one of my reports.In the image given beloww i would basically liske to adjust the on hand demand like the one shown below.   Presently...
sajal161292's avatar
sajal161292
Icon for Helper V rankHelper V
8 years ago

I have modified my pbi file with some calculations and shared it below:

 

https://drive.google.com/drive/folders/12Ou3PcwDie0aju7ZV8ISSbeKsvXdZ6Vp

 

Now i need to make some changes in the way data is being represented in the file.I need to re-adjust the value of on hand quantity of the current week with the cumulative total of the previous week(demand+inbound supply+on Hand).Presently the on hand field is showing the same value for every week(in this example)

 

For week 47:

 

On hand = running total of previous week(46)= 557.72

 

For week 48:

 

On hand =  running total of previous week(46)=-993.83 etc.. till the last week.

 

Adjusting the value of on hand will also change the cumulative total that is being represented for any week.

 

I need to implement this in one of my reports very urgently as it is hampering the progress of it.

 

Any help/pointers will be greatly appreciated!!

 

Please let me know for any question/clarification

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi sajal161292,

 

I think you can add filter to check where the formula is calculated on and use previous result to replace current value.(your visual contains complex grouping columns, it is hard to write a specific condition to filter on it)

 

For example:

 

Modify formula shows total as 0, May,July shows 'custom'.

 

Regards,

Xiaoxin Sheng