Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

Hello ,

 

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

 

dkdr.png

 

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.

 

 

 

1 REPLY 1
Anonymous
Not applicable

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 ... )

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.