Forum Discussion

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

To compute some rows dynamically

Hi,   I am new to Power BI and stuck up while re-computing the value of a field in my report.   I need to adjust the value for the field On hand in the current week as per the previous week's ...
Need Help
sajal161292's avatar
sajal161292
Icon for Helper V rankHelper V
8 years ago

Hi,

 

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

 

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

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

Hi,

 

Can anyone please help me with this?

I am really stuck up on it,have tried to implement this functionality in sql but it has become a way too complex.

 

I need this really badly.

 

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi sajal161292,

     

    Sorry so late. Too much work to do. I found a workaround though it isn't prefect. You can try it and may get some ideas. You can test it in this file.

    Measure =
CALCULATE (
    SUMX (
        SUMMARIZE (
            '0ShortageData',
            '0ShortageData'[Org],
            '0ShortageData'[Part],
            '0Calendar'[Week],
            "value", SUM ( '0ShortageData'[Quantity] )
        ),
        [value]
    ),
    ALL ( '0ShortageData'[OrderType (groups)] ),
    FILTER ( ALL ( '0Calendar' ), '0Calendar'[Week] < MAX ( '0Calendar'[Week] ) )
)

    To_compute_some_rows_dynamically

     

    Best Regards,

    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi sajal161292,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale