Friday 14 December 2018

Nested If in Power BI

To create a nested if please follow the below steps
  1. Open your Power BI desktop 
  2. Go to Modelling 
  3. Go to New Column
  4. Add this below formula.
NestedIfEx = IF(NewTableName [WeekDay] < 30, "Lesser than 30",
IF(NewTableName [WeekDay] > 30, "Greater than 30"))

No comments:

Post a Comment