MulaiMulai sekarang secara gratis

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?

Latihan ini adalah bagian dari kursus

Intermediate Power Query in Excel

Lihat Kursus

Latihan interaktif praktis

Ubah teori menjadi tindakan dengan salah satu latihan interaktif kami.

Mulai berolahraga