Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Hoping somebody can help assist with the renaming of column headers when querying a PowerBI dataset in Excel.
I can live query my required PowerBI dataset in Excel but the column headers are rendered as per the absolute column name (Table[ColumnName]).
My live query looks like this:
DEFINE
VAR __DS0Core =
SUMMARIZE(
'Append1',
[Description],
[Variant Code],
[Main Supplier],
[Supplier]
)
VAR __DS0PrimaryWindowed =
TOPN(
501,
__DS0Core,
[Variant Code],
0,
[Description],
1,
[Main Supplier],
1,
[Supplier],
1
)
EVALUATE
__DS0PrimaryWindowed
ORDER BY
[Variant Code] DESC,
[Description],
[Main Supplier],
[Supplier]
Then excel returns column header names:
Is there a way to rename this column headers, in the DAX query, to "Description", "Variant Code", "Main Supplier" and "Supplier".
Thanks in advance.
I believe SELECTEDCOLUMNS function can rename your columns. Give this a try...
DEFINE
VAR __DS0Core =
SUMMARIZE(
'Append1',
[Description],
[Variant Code],
[Main Supplier],
[Supplier]
)
VAR __DS0PrimaryWindowed =
TOPN(
501,
__DS0Core,
[Variant Code],
0,
[Description],
1,
[Main Supplier],
1,
[Supplier],
1
)
EVALUATE
SELECTCOLUMNS(
__DS0PrimaryWindowed,
"Description", [Description],
"Variant Code", [Variant Code],
"Main Supplier", [Main Supplier],
"Supplier", [Supplier]
)
ORDER BY
[Variant Code] DESC,
[Description],
[Main Supplier],
[Supplier]
Proud to be a Super User!
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |