Obtain the column name,table name, file name ... in dax

[Anonymous]

Hello ,

I own this type of table with my data in line and 6 columns with several quantities :

I use a pivot like this in DAX to create a new table :

newtable=
union(
SUMMARIZECOLUMNS(Feuil1[info 1];Feuil1[info 2];Feuil1[info 3];Feuil1[date];Feuil1[qte segment 1];[?????])
SUMMARIZECOLUMNS(Feuil1[info 1];Feuil1[info 2];Feuil1[info 3];Feuil1[date];Feuil1[qte segment 2];[?????]);
SUMMARIZECOLUMNS(Feuil1[info 1];Feuil1[info 2];Feuil1[info 3];Feuil1[date];Feuil1[qte segment 3];[?????]);
SUMMARIZECOLUMNS(Feuil1[info 1];Feuil1[info 2];Feuil1[info 3];Feuil1[date];Feuil1[qte segment 4];[?????]);
SUMMARIZECOLUMNS(Feuil1[info 1];Feuil1[info 2];Feuil1[info 3];Feuil1[date];Feuil1[qte segment 5];[?????]);
SUMMARIZECOLUMNS(Feuil1[info 1];Feuil1[info 2];Feuil1[info 3];Feuil1[date];Feuil1[qte segment 6];[?????])
)

I want replace " [?????] " by a function in DAX to obtain , the table name and the column name .

In my idea, this function it's similar to the excel function = "CELL( type_info; ...) " . This permit to send address, color, format, sheet, file ... name .

If this function doesn't exist I can create a idea with a vote for a suggestion.

Thanks for your help.

[Anonymous]

Hello,

To add several options in this case of usation, I propose an idea : https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38962018-information-table-and-co... .

For example to personalise a format (date if it's a datetime, a name of table source when you own a multiple flow / table to merge in 1 queue, when you must process several information about several subsiduaries and Databases sources ... )