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

Hi,

 

I am unable to attach my pbix file in the message.

So could you please tell me a way to do this?

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Upload the file to Google Drive and share the download link here.

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

    Hi,

     

    Thank you for help.

    I have uploaded my file in the location below:

     

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

     

    In the file if you will click on B then a screenshot will appear as follows

     

     

     

    So now I would like to see the previous week's running total value in the on hand supply part till last week and again calcluate the running total with the newly adjusted values.

     

    Thanks.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      Hi,

       

      I need permissino to download the file.

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

        Hi,

         

        I have updated my test file with some changes in the calculation for running total

         

        I need to change my pbi file as follows:

        The cumulative total for a previous week should be assigned to the on hand quantity of next week.

         

        week 47:

         

        On hand = total of week 46 = 557.72

         

        week 48:

         

        On hand = total of week 47 =  -993.83

         

        week 49:

         

        On hand = total of week 48 = -1551.55 +(- 993.83) = -2545.83

         

        and like this in the remaining weeks.

         

         

        Please find the updated link below.

         

        https://drive.google.com/drive/folders/12Ou3PcwDie0aju7ZV8ISSbeKsvXdZ6Vp?usp=sharing

         

        I need to implement this in one of my report very urgently.

         

        Any help will be greatly appreciated!!