Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Is there a DAX command for retrieving a column name.
Preferably the original query column name and not the renamed one.
The reason why is …..
I have a data model with 100’s of fields like
DimProduct
Unit Price
Weight
I also have a data dictionary on a sql server table with a list of each column name with description.
I want to be able to hover on a visual graph segment and then for Power BI to retrieve the original column name and do a lookup to get and display the data dictionary description.
Solved! Go to Solution.
Hi @speedramps
Currently, Dax doesn't support to get columns' names, you could use Power Query to get columns names.
Sample
Custom=Table.ColumnNames(#"previousSteps"){0}
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
NAMEOF is the DAX function you're looking for.
Hi @speedramps
Currently, Dax doesn't support to get columns' names, you could use Power Query to get columns names.
Sample
Custom=Table.ColumnNames(#"previousSteps"){0}
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
65 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
86 | |
75 | |
56 | |
50 | |
45 |