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
Gordonlilj's avatar
Gordonlilj
Solution Sage
6 years ago

Hi,

 

Are you creating the column in the power query editor? if so the code you're using will not work as it's using DAX (power query uses M). The code should work if you create a calculated column instead.

 

If you want to create it using a custom column in power query then the code below should work

if [Aging] >60 and [Aging]<365 then [Total PD] else 0