Forum Discussion
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...
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
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
Thank you so much, greatly appreciated