Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

DAX help

Hi, I have data as mentioned below and wanted to create New Val calculated column, whenever there is negative make it zero and next row record should be substracted negative values.   In the below...
Need Help
  • Kishore_KVN's avatar
    Kishore_KVN
    1 year ago

    Hello Anonymous ,
    I can suggest quickly with the help of creating INDEX in Power Query. 

    DAX for the new column will be like below:

    New Value = 
VAR PV = LOOKUPVALUE('Table'[Val],'Table'[Index],'Table'[Index]-1)
RETURN
IF('Table'[Val]<0,0,
IF('Table'[Index] =1,'Table'[Val],
IF('Table'[Val]>0 && PV < 0, 'Table'[Val] + PV , 'Table'[Val])))

    Output looks as below:

    Attached pbix as well for your refrence. 

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

v-priyankata's avatar
v-priyankata
Community Support
1 year ago

Hi Anonymous 

Thanks Kishore_KVN bhanu_gautam for your inputs, Anonymous May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.