cheers519
Reputation: 455
How to pass contant string value for a column in SUMMARIZECOLUMN
I want to pass a constant string value i.e. Not Applicable for one of the column values that will be used in SUMMARIZECOLUMNS function. But I am not find any format in how to do the same.
Upvotes: 0
Views: 850
Answers (1)
Himanshu Agrawal
Reputation: 271
SUMMARIZECOLUMNS( table_name[column_name], "Custom_Column_Name", "Not Applicable")
Upvotes: 2
Related Questions
- Pass a Parameter to DAX Query Report Builder
- Use value from SUMMARIZECOLUMNS as filter in CALCULATE
- Power BI DAX How to add column to a calculated table that summarizes another
- SUMMARIZECOLUMNS handling multiple columns with the same name
- Sum of a Column resulting from Summarize Function in DAX
- Filter SUMMARIZECOLUMNS
- Optimizing Summarize in DAX
- Use SUMMARIZECOLUMNS on table union in DAX query
- SSAS Tabular - How to use FORMAT function in DAX summarize function
- Pass parameter to DAX query