Forum Discussion
Calculated Column with IF Then from multiple columns
I have a table with a list of records that were associated with multiple people. Each person can record what they did to the record (Disposition1 - 5). I'm trying to create a calculated column to s...
Hi Wilson,
Thank you for the break down on the SWITCH function. Unfortunately, it still doesn't get past the first statement and still only uses Disposition2.
cstanley1543,
Like I said, if that doesn't correct the issue, maybe confirm with your data that there are any records where the Disposition1 or Disposition2 columns are not "BU". It could be that it's legitimately not reaching to the later conditions.
If you're still having issues, any chance you could share an anonymized pbix file?
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)