Forum Discussion

Terp's avatar
Terp
Advocate 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
Advocate III
4 years ago

...added 4 or 5 conditions and learned the order of operation matters, too. Nice. Always impressed with the simplicity and power under the hood. That was too easy doing it in PQ, sir. Good call. ðŸ™‚

 

  • davehus's avatar
    davehus
    Memorable Member
    4 years ago

    It's very good and the syntax for and/or is easy to understand.