Forum Discussion
Beginner question - IF statement
Hi! Im totally new to BI since our company has moved from Tableau recently. I work at customer service and I need to set up a calculation to show our Service Level %. We have two brands where...
Hi, Anonymous
Because he uses column and you use measure, measure can only get aggregated values, so it won't display column name directly.
Do you want to calculate this average at one time? Or you also needs to show 0 and 1 in other column.
As they said, 'upload some insensitive data samples and expected output' will get accurate help.
Best Regards,
Community Support Team _ Janey
Thanks for all your help. Finally got it to work with this (BRAND_KEY) is just the numeral version of the brand names:
IF('dwh_fact f_css_data'[WAIT_TIME_IN_QUE] > 90 && 'dwh_fact f_css_data'[BRAND_KEY] = 4 ,0 , IF('dwh_fact f_css_data'[WAIT_TIME_IN_QUE] > 120 && 'dwh_fact f_css_data'[BRAND_KEY] = 14, 0, 1))
And the learning continues 🙂