Kindly use below data for practical.......
https://docs.google.com/spreadsheets/...
Conditional Column in Power BI
A Conditional Column in Power BI is a custom column created in Power Query Editor that assigns values based on specified conditions. It works like an IF-ELSE statement, allowing data to be categorized or transformed automatically according to business rules.