Forum Discussion

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