Forum Discussion

jamuka's avatar
jamuka
Icon for Helper IV rankHelper IV
7 years ago

Running Total based on two value

Hello,   I'm using Power BI for the first time and I stucked in running totals. I need to sum my forecast amount based on stock location (Store, Warehouse and Without Stock).   I want to show run...
Need Help
Show and Tell
Tips and Tricks
  • jamuka's avatar
    jamuka
    Icon for Helper IV rankHelper IV
    7 years ago

    Hello v-chuncz-msft thank your your reply.

     

    code in the link summarize forecast amount for all items based on min item no.

    what I need is running total for forecast amount starting from max value based on stock locations of Store and Warehouse and once for each article. e.g item no "1" should be used once not twice.

    Also could it be possible to have it as a column? As I understand measure and column formulas are different from each other.

     

    regards