How to streamline else if statements in Power Query M for a new Add Conditional Column
I created a new Conditional Column named [CATEGORY] based on many different values in a column named [MERCHANT].
I’m categorizing the values in the MERCHANT columns.
Many of the values in MERCHANT will change each month.