Use column data as table name

[magallane]

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

[ppm1]

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