Forum Discussion
Solved
IF and Statement in Excel Power Query
I am trying to create below scenario in excel power query, where I'm getting when trying to create Point. 2 & 3 table as below Type Amount_A Amount_B Amount_C New 8921 ...
in the example data you gave the Amount_A values were null.
Changed the code so it works with = 0 too 🙂if [Amount_A] = null or [Amount_A] = 0 then
if [Amount_C] = null or [Amount_C] = 0 then
if [Amount_B] = 0 or [Amount_B] = nullthen null
else "Expiring"
else "Renewed"
else [Type]
my bad .. I changed it to 0 in last moment while uploading to make it more simple which missed your first line of code.. thank you so much
Glad I could help!