Forum Discussion

dodiyal's avatar
dodiyal
Frequent Visitor
4 years ago
Solved

Subtracting values in same column until the value becomes 0

Hello Team,   I have a data set where i have to subtract value untill its zero can you please help me. I need dax to solve- Please see the data week      sale Week1    10 week2     5 week3    ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Thank you for your feedback, and please check the below picture and the attached pbix file.

     

     

  • dodiyal's avatar
    dodiyal
    3 years ago

    hi

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I am not sure if I understood correctly your question, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

I hope the below can provide some ideas on how to create a solution for your dataset.

 

 

Expected measure: = 
CALCULATE ( [Sales total:], REMOVEFILTERS () )
    - CALCULATE ( [Sales total:], Data[Week] <= MAX ( Data[Week] ) )