Forum Discussion
Variable in column name in summarize table
I am creating a calculated table by summarizing date, country, branch and sales amount from Table Sales
Branch_Sales_calc =
var branch = 'Parameter'[Branch] -- value is from query parameter
)
If I change the column name "BranchName" to variable branch I get the error - Function SUMMARIZE expects a column name as argument number 4
Anonymous Currently it is not supported to change the column name dynamically with the parameter.
As a workaround, I suggest using fixed "Sales" or "Total Sales" as the name of this column to indicate what this column's data describes. Then format the visual's title conditionally with the field 'Parameter'[Branch] to let users know which branch this data represents for.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
7 Replies
- mahoneypat
Microsoft Employee
Oh. You can't use a variable where "BranchName" is. Why is that needed? Why not use a fixed name that reflects what is in that column like "TotalSales"? If needed, you could add another column to your table that has the branch name on every row.
Regards,
Pat
- amitchandak
Super User
Anonymous , I doubt you can use a slicer value or parameter in a new table creation
also try changing var like and try
var branch = max('Parameter'[Branch] )
v-jingzhangCommunity Support
Anonymous Currently it is not supported to change the column name dynamically with the parameter.
As a workaround, I suggest using fixed "Sales" or "Total Sales" as the name of this column to indicate what this column's data describes. Then format the visual's title conditionally with the field 'Parameter'[Branch] to let users know which branch this data represents for.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
- mahoneypat
Is Parameter a text value? Or is it a 1-row/1-column table? If a table, you need to aggregate it with MIN('Parameter'[branch]) for example.
Regards,
Pat
