Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

IF AND statement Power Query

Hi. I'm trying to add new custom column using IF AND statement. If "Aging" is greater than 60, and "Aging" is less than 365, give "Total PD". If(and(Aging>60,Aging<365),Total PD,0)   It seems like...
Need Help
Show and Tell
Tips and Tricks
rsimonsen's avatar
rsimonsen
Frequent Visitor
6 years ago

ahjlim32

If you are doing this with Power Query Editor then Gordonlilj solution is the way to go. If you are using the add new column under modeling this should work.

IfTest = if(and([Aging]>60,[Aging]<365),[Total PD],0)