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

...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. ðŸ™‚