Forum Discussion

sajal161292's avatar
sajal161292
Helper 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
Helper V
8 years ago

Hi,

 

Thank you for your reply.

My pbix file is having some private data.So is there any way to share it with you by hiding the data that is private?

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Dummy your dataset and then share the download link.

  • sajal161292's avatar
    sajal161292
    Helper 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
      Super User
      8 years ago

      Hi,

       

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

      • sajal161292's avatar
        sajal161292
        Helper 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.