combining monthly comlumn chart with a messure for the active month

[Pete230]

Hi guys,

I would like to create a colum chart (monthly values for the year), it should consist out of 3 categories:

1. Actual data for all passt months (red marked in screenshot), source: table in dataverse
2. mixture betwen actual data and prognosis (until yesterday real data and from today until the ofm prognosis data), this I calculate in a messure (marked yellow) in the screenshot)
3. prognosis data for the coming months, source: table in dataverse (marked in black in the screenshot)

The past month are monthly data, the actualy moth containb daily data for actual and prognosis, the coming data are daily data.
My first Idea was to create a querry with my calendar table, but since I mix monthly and daily data and since everyday (and month) has many different values to be shown, it seems to me pretty unusable.

Does anyone know how to achiev that?

The end resulst should be visible monthly, as the screeenshot shown above.

Thank you and cheers

Pete