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...
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

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

Hi Anonymous,

 

I have modified my pbi file with adding up a new measure for representing the previous week sales.

Additionally i have added a new order type as Total.

 

Now i am stuck up while re-assigning the value of previous week sales to the field Total.

Is there any way to perform iteration in DAX and traverse for each record?

 

Please find the link of new pbi file below

 

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

 

 

Thanks for your help!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI sajal161292,

     

    >>Is there any way to perform iteration in DAX and traverse for each record?

    It is possible to achieve this, but you need to add huge amount of conditions to help measures confirm where current content calculated. 

     

    In my opinion, power bi not support auto/dynamic calculate on complex measures(exist some specific filters, contains break row contents function e.g. 'all/allexcept').

     

    Notice: if your data contains any privacy data, please do mask sensitive data before sharing.

     

    Regards,

    Xiaoxin Sheng

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

    Hi,

     

    So will it be possible to perform this operation in DAX?

     

    Thanks

    Har**bleep**a Singh