Forum Discussion
Solved
Create custom column based on values in multiple other columns
Hello! I have columns for values that compare how a provider is utilizing office visit codes versus their peer group. I need to flag values at certain thresholds so I created custom columns to fl...
I decided it would be easier to just create a new column using DAX, which is probably what I should have done from the start. Anywho, my DAX code for the column looks like this:
99215 Potential = IF( EstVisits_21Q1[99215 Diff] < -0.1 && NOT( EstVisits_21Q1[99212 Opportunity] = 1 || EstVisits_21Q1[99213 Opportunity] = 1 || EstVisits_21Q1[99214 Opportunity] = 1 ), 1, 0 )
Try this:
Just place parentheses before [99212 Opportunity] and then after [99214 Opportunity] so that all of the "or"s after the "and" are a single parenthesized statement.
--Nate
I tried the parentheses but that didn't work.