Converting Excel nested If/and statements to Power Query

[VTM12]

Hi, I'm new to Power Queries and am having trouble converting a formula to work in Power Query.  I understand I use if/and/then/else, however I have created custom columns in my power query where a lot of the values are null and I'm getting error messages.  My formula in excel is:  =IF(AND($G28<="31/12/2018"*1,$H28=""),$K28,IF(AND($G28<="31/12/2018"*1,$H28<="31/12/2018"*1),$B28,IF(AND($G28<="31/12/2018"*1,$H28>"31/12/2018"*1),$K28,0))).   Any advice would be helpful.  Thanks.

[v-chuncz-msft · Accepted solution]

@VTM12,

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/IF-Statement-using-Power-Query/td-p/122030