Rename Column in Table Created with UNION and SUMMARIZECOLUMNS

[CS]

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.

[Zubair_Muhammad · Accepted 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])

[CS]

Worked like a charm. Thank you.