Forum Discussion

magallane's avatar
magallane
New Member
3 years ago

Use column data as table name

Hi. I have X tables with data from X windfarms. Table1 ... TableX.

I have a third table with a summary of every windfarm. In this table, my first column have the name of the other tables: Table1 ... TableX and in the second column column2. I'd like to have a the same formula for every row (every windfarm) but using column1 as tablename. For example: count(TableX[alarms]). How can I do this? Use column1 as table names in column2's formula.

 

Regards

 

 

 

 

 

Need Help

1 Reply

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    You should append all your windfarm tables together. If needed, add a column to each first to give the windfarm id (to relate to your summary table, if needed). If your tables come from files, you can use the Combine & Transform feature of Power Query.

     

    Trying to create visuals and analyze your data from separate tables would be difficult. Appending will be much better for you.

     

    Pat