Power Query - Conditional column based on another column

[Harry_Tran]

Hi,

I have 2 tables

table 1

table 2

I try to create a conditinal column for table 2

<= 30 = If table1[Aging] <= 30 then Sale else 0

>30 = If table1[Aging] > 30 then Sale else 0

Thank you for your help!

[Padycosmos]

Please try the following:

If (table1[Aging])<= 30 ,[Sale],0)

 If (table1[Aging] > 30,[Sale],0)

[ChrisMendoza]

@Harry_Tran - It looks like Solved: Re: How to lookup values in another table in the Q... - Microsoft Power BI Community does the trick for you.

= Table.AddColumn(#"Changed Type", "<=30", each if (let currentID = [ID] in Table.SelectRows(#"table 1", each [ID] = currentID)){0}[Aging] <= 30 then [Sale] else 0)

= Table.AddColumn(#"Added Custom", ">30", each if (let currentID = [ID] in Table.SelectRows(#"table 1", each [ID] = currentID)){0}[Aging] > 30 then [Sale] else 0)