Forum Discussion
Power Query if
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+"))))
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+"
1 Reply
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+"