Alias on SummarizedColums Year-Montno.

[Anonymous]

I want my Year-Monthno filed to be names Period in this query. How to a put an alias on it?

EVALUATE SUMMARIZECOLUMNS('Planned Finnished Date'[Year-Monthno.],
FILTER(VALUES('Planned Finnished Date'[Last X Calendar Months]), 'Planned Finnished Date'[Last X Calendar Months] >= VALUE("1")
&& 'Planned Finnished Date'[Last X Calendar Months] <= VALUE("10")),
"Value", [UH7 Finished On TIme VS Total Tasks],
"Target", [UH7 Finished On Time VS Total Task Target],
"Limit", [UH7 Finished On TIme VS Total Task Threshold 1])

[amitchandak · Accepted solution]

@Anonymous , put a selectcolumns on top of it and rename the columns and try

example

selectcolumns(SUMMARIZECOLUMNS('Planned Finnished Date'[Year-Monthno.],
FILTER(VALUES('Planned Finnished Date'[Last X Calendar Months]), 'Planned Finnished Date'[Last X Calendar Months] >= VALUE("1")
&& 'Planned Finnished Date'[Last X Calendar Months] <= VALUE("10")),
"Value", [UH7 Finished On TIme VS Total Tasks],
"Target", [UH7 Finished On Time VS Total Task Target],
"Limit", [UH7 Finished On TIme VS Total Task Threshold 1]) ,  "month year" ,[Year-Monthno.] ,"Value" , [Value],

"Target" , [Target], "Limit",[Limit])