Transpose a table in directquery dynamically

Hello all,

I'm trying to transpose a table provided by SQL. The table contains all the dates that I'm going to use and it will be updated constantly so the transpose one should be dynamically created.

This is my table that has all the dates. This table should be created in columns to relate it to another table containing the values.

The problem is that I want the table to be created dynamically in case of modifications in the dates.
I have tried to create a transposed table with DAX formula but I have to write by hand the title of the column so it is not dynamic...

Thanks for all your help as always 😁