Transpose a table in directquery dynamically

[Anonymous]

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 😁

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523