Forum Discussion
Create a new table based on another table's headers
Morning all,
I would like to create a series of tables based on the headers from a Parent table and after each column will be a “countA” of the values from the parent table.
Any idea of how to do it?
Regards
Can you provide same data and expected output? Do you want to do this in Power Query or DAX or does it matter?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490. In Power Query there is a Table.ColumnNames that you could potentially use:
https://msdn.microsoft.com/en-us/query-bi/m/table-columnnames
Hello Greg,
the small example is, a table with headings where the first colum is the unique ID for the data base and them 30 columns of properties, no all the properties are fill in and what i would like is to create another table, based on the headings from the previus and count for each column how many properties are completed. that means that I know the number of unique ID and the numbers for each property and able to calculate the %.
I need to repet this process for 200 different tables.
Could Power BI do something like this?
