As a real newbie to Power Query I now have a problem that I can´t solve.
I´ve created a Power Query table in a normal Excel worksheet and it´s working well.
It´s actually just a couple of columns which are connected to a website with live football results.
What I want is Excel to use the result from Power Query and then do further calculations.
Let´s say Power Querys cell "C3" displays value "2" (=away team leads).
I then want Excel cell "D3" to display that value, I just write =C3 in cell "D3" and it returns "2". So far so good.
The problems start when I want Excel to do some further calculations.
Let´s say I want Excel to compare the result from Power Query (Cell "D3") with a lot of lines with
different symbols. For example, in cell "E3" I have the value "2". I now want Excel cell "E4" to return a "1" if E3=D3:
normally I just have to write (in cell "E4"): =IF(E3=D3,1,0).
That´s always works but now it seems impossible, just because the value comes from Power Query. I´ve tried to format the cells in "all ways"
but no luck. Surely it must be possible? I guess you could do it all in Power Query but I rather use Excel since
it´s much, much faster. I just want to fetch the result with Power Query and then use Excel for all calculations. Any ideas?
I´ve created a Power Query table in a normal Excel worksheet and it´s working well.
It´s actually just a couple of columns which are connected to a website with live football results.
What I want is Excel to use the result from Power Query and then do further calculations.
Let´s say Power Querys cell "C3" displays value "2" (=away team leads).
I then want Excel cell "D3" to display that value, I just write =C3 in cell "D3" and it returns "2". So far so good.
The problems start when I want Excel to do some further calculations.
Let´s say I want Excel to compare the result from Power Query (Cell "D3") with a lot of lines with
different symbols. For example, in cell "E3" I have the value "2". I now want Excel cell "E4" to return a "1" if E3=D3:
normally I just have to write (in cell "E4"): =IF(E3=D3,1,0).
That´s always works but now it seems impossible, just because the value comes from Power Query. I´ve tried to format the cells in "all ways"
but no luck. Surely it must be possible? I guess you could do it all in Power Query but I rather use Excel since
it´s much, much faster. I just want to fetch the result with Power Query and then use Excel for all calculations. Any ideas?
