Forum Discussion

Sushant__08's avatar
Sushant__08
Regular Visitor
2 years ago
Solved

To add a column in Power BI using if - else functions

Dear All,   I am new to Power BI and was having issues in creating a new column.   Present table in Power BI is as below:     And I want to a new column named "EAC BQ" at the end as per ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    To accommodate the updated requirements, here’s the revised DAX formula. This formula checks both if the ‘EACBQFlag’ column is not blank and contains either "Model" or "Forecast" and assigns the respective BQ column value directly. If the ‘EACBQFlag’ column is blank, it uses the ‘status’ column to determine the value:

     

    NewColumn =

    SWITCH(

        TRUE(),

        'YourTable'[EACBQFlag] = "Model", 'YourTable'[Model BQ],

        'YourTable'[EACBQFlag] = "Forecast", 'YourTable'[Forecast BQ],

        ISBLANK('YourTable'[EACBQFlag]) && 'YourTable'[status] = "Before Design Start", 'YourTable'[Target BQ],

        ISBLANK('YourTable'[EACBQFlag]) && 'YourTable'[status] = "Design Started", 'YourTable'[Forecast BQ],

        ISBLANK('YourTable'[EACBQFlag]) && 'YourTable'[status] = "FR Issued", 'YourTable'[Model BQ],

        ISBLANK('YourTable'[EACBQFlag]) && 'YourTable'[status] = "FC Issued", 'YourTable'[Model BQ],

        BLANK()

    )

    Regards,

    Chiranjeevi Kudupudi

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Sushant__08 ,

 

Thanks for your help, rajendraongole1 .

Her's the calculated column with DAX:

 

EAC BQ = SWITCH([EACBQFlag],"",[Status],"Model","Model BQ","Forecast","Forecast BQ")

 

Or:

 

EAC BQ 2 = IF([EACBQFlag]=BLANK(),[Status],IF([EACBQFlag]="Model","Model BQ",IF([EACBQFlag]="Forecast","Forecast BQ")))

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sushant__08's avatar
Sushant__08
Regular Visitor
2 years ago

Thank you Anonymous ,

 

But I was to assign numerical values in the new column "EAC BQ" from the available BQ data.

 

Like,

 

If "EACBQ flag" is blank, then my intention is to select a BQ data based on the status update. Like,

 

Status = Before Design Start ; Data = number / data in "Target BQ" column

 

Status = "Design Started" ; Data = Number in "Forecast BQ" column

 

Status = "FR Issued" ; Data = Number in "Model BQ" column

 

Status = "FC Issued" ; Data = Number in "Model BQ" column

 

But if EACBQ Flag column is not empty. If EACBQ Flag = "Model" then "EAC BQ" = number in "Model BQ" column.

 

Similarly,

 

If EACBQ Flag = "Forecast", then EAC BQ = Number in "Forecast BQ" column.

 

It is a bit confusing but could you please help me. I am stuck in this report from last few days.

 

Thanks so much for your attention.