Forum Discussion
Solved
Multiple Conditions/Ifs and Calculated Columns
I am trying to clean up some data, but still don't have a strong command of DAX (work-in-progress). 🙂 In short, they have a mix of 'regions' and 'countries' and some duplicative aggregates (e.g....
Hi Terp, I'd suggest creating this process in Powerquery using a conditional column. It has an easier logic to it and is preprocessed as opposed to being a calculated Dax column.
Thank you, sir...never did one using PowerQuery, but after adding a few conditions (and figuring out how to address the null), it indeed worked well!
...will work on my DAX to figure out the compounding thing, but this definately solves many problems. Thanks again.
No problem, I find doing a lot of this upstream in the etl stage or back at the source if possible. It's best all round for report performance. 😊