Combine two time series into one view

InfluxDB 2 Dashboards
,
1

I’m using grafana to visualize measurement data from InfluxDB.

I have a time series like this.

My query:
SELECT "Value" FROM "data/power/value", "data/count/value"

Which gives me following table:

TIME				Count			Power
28.11.2019 16:34		12			-
28.11.2019 16:34		-			200
28.11.2019 16:34		-			40
28.11.2019 16:34		-			0
28.11.2019 16:34		11			-
28.11.2019 16:34		-			201
28.11.2019 16:34		-			163
28.11.2019 16:34		-			123
28.11.2019 16:34		-			82
28.11.2019 16:34		10			-
28.11.2019 16:34		-			202
28.11.2019 16:34		-			0
28.11.2019 16:34		9			-
28.11.2019 16:34		-			200
28.11.2019 16:34		8			-
28.11.2019 16:34		-			202

But what I’m looking for is, for every Count entry get the last Power entry.
Like this:

TIME				Count			Power
28.11.2019 16:34		12			200
28.11.2019 16:34		11			201
28.11.2019 16:34		10			202
28.11.2019 16:34		9			200
28.11.2019 16:34		8			202

I want only visualize the data as table using Grafana. How can I achieve this in InfluxDB QL?

Thank you in advance.