Forum Discussion

Mechi's avatar
Mechi
Helper I
6 years ago
Solved

Create New table based on the selected existing table column headers

Hello,  I need a small help in creating new tables based on the column headers of existing table   For example if i have the following existing table Number T1 T2 T3 Avl 5645 X   X ...
Need Help
  • AnkitBI's avatar
    AnkitBI
    6 years ago
    Don't think you can extract Column Names in separate table using DAX. May be someone else be able to help.
Mechi's avatar
Mechi
Helper I
6 years ago

AnkitBI , Thanks for the Code

But i needs to create this table outside of Edit Query, Would be great help if i can able to do this in Modelling --> New Table using DAX formulas

 

BR

Mechi ğŸ”§

v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

Hi Mechi ，

Currently, using DAX to extract column headers is not possible, you need to use M Query.

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.