Power Query if

[M_SBS_6]

Hi, 

I have this DAX logic but i want to have this in the backend using Power Query. How or where do I write the following logic in Power Query please? 

If(isblank(house_val), "",

If(house_val >=0 && house_val < 50000, "0-49000,

If(house_val >=50000 && house_val < 100000, "50000-990000, 

If(house_val >=100000 && house_val < 500000, "100000-490000,

"500000+"))))

[amitchandak · Accepted solution]

@M_SBS_6 , Try in Power query

if [house_val] >= 0 and [house_val] < 50000 then "0-49000" else
if [house_val] >= 50000 and [house_val] < 100000 then "50000-99000" else
if [house_val] >= 100000 and [house_val] < 500000 then "100000-490000" else
"500000+"