I am creating a table in Power BI with the following formula:
SlicerDates = UNION( SUMMARIZECOLUMNS( Dates[End of Month], "Time Period", "Month" ), SUMMARIZECOLUMNS( Dates[End of Quarter], "Time Period", "Quarter" ) )
The unioned table has the right data, but the column with the dates is named "End of Month." Is there a way to rename this column in this formula? I looked at SELECTCOLUMNS but could not find a way to reference the table column created with the UNION statement.
Solved! Go to Solution.
Hi @CS
try this
SlicerDates = VAR mytable= UNION( SUMMARIZECOLUMNS( Dates[End of Month], "Time Period", "Month" ), SUMMARIZECOLUMNS( Dates[End of Quarter], "Time Period", "Quarter" ) ) RETURN SELECTCOLUMNS(mytable,"End of Period",[End of Month],"Time Period",[Time Period])
Hi @CS
try this
SlicerDates = VAR mytable= UNION( SUMMARIZECOLUMNS( Dates[End of Month], "Time Period", "Month" ), SUMMARIZECOLUMNS( Dates[End of Quarter], "Time Period", "Quarter" ) ) RETURN SELECTCOLUMNS(mytable,"End of Period",[End of Month],"Time Period",[Time Period])
Worked like a charm. Thank you.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
456 | |
173 | |
121 | |
57 | |
52 |
User | Count |
---|---|
452 | |
147 | |
129 | |
74 | |
73 |