Tag Archives: Add Conditional Column

Add conditional columns with #Excel Power Query

Situation: We are given a simple table on the left. We need to add three additional columns based on the prefix of the StoreID, and the sales values. The table on the right is the expected outcome. And here’s the … Continue reading

Rate this:

Posted in Power Query | Tagged , | Leave a comment