Hello everyone,
I am struggling with a request and I am not sure whether I am blind to an obvious solution?
I have a fairly simple set of data that gets updated daily, covering data from a week. It looks like this:
Now I have been asked to set up a report that covers the daily developments and only needs to be refreshed to work (which is achieved with PowerQuery and a macro).
However, the resulting data is not quite in the desired format. If I aggrete in PowerQuery or within a PivotTable afterwards, it looks like this:
Is there any way of repeating the two columns, but showing only the relevant entries for a certain date? This is what we are looking for:
Maybe I am blind to an obvious solution here, but what is the best way to achieve this layout? If the input variable would be static, I would know how to use CUBE functions, but all of them - dates, routes, time - are frequently changing.
Is there a smart way to achieve this? Any input is appreciated!
Kind regards!
I am struggling with a request and I am not sure whether I am blind to an obvious solution?
I have a fairly simple set of data that gets updated daily, covering data from a week. It looks like this:
Now I have been asked to set up a report that covers the daily developments and only needs to be refreshed to work (which is achieved with PowerQuery and a macro).
However, the resulting data is not quite in the desired format. If I aggrete in PowerQuery or within a PivotTable afterwards, it looks like this:
Is there any way of repeating the two columns, but showing only the relevant entries for a certain date? This is what we are looking for:
Maybe I am blind to an obvious solution here, but what is the best way to achieve this layout? If the input variable would be static, I would know how to use CUBE functions, but all of them - dates, routes, time - are frequently changing.
Is there a smart way to achieve this? Any input is appreciated!
Kind regards!
