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,
This is possible to have 2 arguments in a conditional statement.
For an Example,
Column = IF(AND(PBI_Data_2[Region1]= "East", PBI_Data_2[Representative1] = "Parent"),"Fully Depriciated",
IF(PBI_Data_2[Region1] = "East" && PBI_Data_2[Item1] = "Pen","Fully Depriciated","Not Depriciated"))
You can && operator for both the conditions or use AND before and delimited by , in between both the conditions.
I think, this would be helpful for you.
Regards,
Pradeep
Thank you so much