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 ,
One sample for your reference. Here I create a calculated column as below.
Column =
IF (
AND ( Table1[type] = "laptop", Table1[age] = 5 ),
"fully depreciated",
IF (
AND ( Table1[type] = "desktop", Table1[age] = 6 ),
"fully depreciated",
"else"
)
)
Pbix as attached.
Regards.
Frank
Thanks so much, I am very grateful for the assistance - this is the erro I get
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