How can I transform this Excel formula in a table to a custom column in Power Query
Posted on 2015-02-22
I have a formula in an Excel table, that looks like you can see below. I want to be able to find the same value in PowerQuery, but I am not experienced in adding columns in PowerQuery.
I have tried to copy the formula into the column Tool and convert the column names of the Excel table to the columns that are in the importdata in PowerQuery, and I have tried to make the if statement Work, but have had no luck.
The content of the placement cell could be something like
"1600-1700=2," telling that between 16 and 17 there have been used two lanes summing up to 2 lanes (1 hour times 2 lanes)
"1700-1900=1," telling that between 17 and 19 there have been used one lane, which should sum up to 2 lanes (2 hours times 1 lane)