Conditional logic with M
Imagine you have a dataset with a Sales
column and a Region
column.
Your goal is to create a new custom column called "Bonus", where you award a bonus of 10% of sales in the "North" region and 5% to sales in the "South" region while keeping sales in other regions unchanged.
How would you write the conditional logic in Power Query to achieve this?
Diese Übung ist Teil des Kurses
Intermediate Power Query in Excel
Interaktive Übung
In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.
