Forum Discussion

PKPK90's avatar
PKPK90
Icon for Helper I rankHelper I
2 years ago

DAX previous row value in calculation

  Hi, am trying to create dax formula based on logic from excel: NORM is what I would like to achieve  NORM=IF(AND(BM3=1,BL2<0),BL2,IF(AND(BM3=1,BL2>0),IF(BL2+(G3-H3+BD3-BE3)>0,BL2+(G3-H3+BD3-BE3),...
PKPK90's avatar
PKPK90
Icon for Helper I rankHelper I
2 years ago

Hi, thank you for your reply. In your message, you are referring to the NORM column, which is just an example of what I hope to achieve with the DAX calculation. The NORM column should not be included in the calculation.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi bhanu_gautam ,thanks for the quick reply, I'll add more.

Hi PKPK90 ,

Regarding your question, I think DAX cannot meet your needs, you need to use Power Query to do iterative calculations.

 

Best Regards,
Wenbin Zhou