Forum Discussion

MoiraBannister's avatar
MoiraBannister
Regular Visitor
7 years ago
Solved

PowerBI

Good morning, still a novice with PowerBI but loving it - need some guidance Is it possible to have 2 arguments in a conditional column - i.e. if the device type is laptop and the age is 5 = fully d...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi MoiraBannister ,

     

    To create a custom column in power query. We can use the formula as below.

     

    if [type] = "laptop" and [age] = 5 then "fully depreciated" else if [type]="desktop" and [age]=6 then "fully depreciated" else "else"

     

    Regards,

    Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

You can simply use the option to add a conditional column in the 'add column' tab (query editor). While using this option you can add lines per condition. 

 

Power BI will write the coding for you using this option.

 

Hope this is helpfull!

 

Regards