Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Create columns in a list

I have a query that comes from multiple databases with many columns each. From the query I want to extract 10 columns (number of projects) The problem is that in the future there will be more proje...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

I understand that what I'm asking for can't be done with Power BI, right?

The problem comes from the database, which is a database in matrix format (I can't change it) and above it's a range and not a table (I can't change it either):

LEJ_0-1653919131299.png

This is a record of hours and each column is a "task".

Before depivotizing, I have to select which columns I do not want to use (which are many). But in the future, when I create new tasks, I do not want to be changing the report.