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...

Need Help

cathoms

5 years ago

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
)

Forum Discussion

Create custom column based on values in multiple other columns

Related content

Create columns group

Create custom column based on multiple rows

Sequential Order column based on multiple criteria

Creating multiple Audiences in PowerBI App

Multiple line and clustered columns chart