Convert multiple excel formulas to single DAX formula

[Grinch356]

Hi,
I am trying to find a way in powerpivot of combining three 4 validation test columns into one column. The idea is that if the result in test 3 comes up with 'Exclude', I will filter it out of of a measure for a calculation I am doing. I have demonstated the calculations I am trying to combine in fields k-n, not sure if anyone can help arrive at this result in one single powerpivot calculation - thanks for looking at this if you can help.
https://onedrive.live.com/redir?res...344&authkey=!ABsaTOjjG2RAYHU&ithint=file,xlsx

 

[scottsen]

Certainly doable. I'm sure I messed up field names and parens, but it is something like:

If ([TOT_DEMAND]+[Original]+[Revised] = 0, "EXCLUDE - ZERO DATA",
  IF([TOT_DEMAND] > 6, "KEEP", 
  IF([Original]+[Revised] < 0.49, "Exclude - Residual Forecast", 
  "KEEP")
))

 

[Grinch356]

Hi,

This worked perfectly! Thank you so much for your help!