Forum Discussion

Terp's avatar
Terp
Icon for Advocate III rankAdvocate III
4 years ago
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....
Need Help
  • davehus's avatar
    davehus
    4 years ago

    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. 

Terp's avatar
Terp
Icon for Advocate III rankAdvocate III
4 years ago

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.

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

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