Forum Discussion
Help with conditional columns referencing total amounts
I need some insight into how to create the following in either power query or power BI I have a series of zipcodes that I am referencing the individual zip code % yes confidence interval (margin ...
In Power Query, Duplicate the table and 'Keep Rows' -> Bottom 1.
This will give you a 1 row table with the Totals line in it. Re-name this table Totals.
In the original table, add a column with this code
if [LCI] < List.First(Totals[LCI]) and [UCI] < List.First(Totals[UCI]) then "LOWER" else if [LCI] > List.First(Totals[LCI]) and [UCI] > List.First(Totals[UCI]) then "HIGHER" else "SAME"
Thank you!