Alias on SummarizedColums Year-Montno.

Anonymous — Fri, 18 Dec 2020 15:51:04 GMT

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])

Re: Alias on SummarizedColums Year-Montno.

amitchandak — Fri, 18 Dec 2020 16:01:36 GMT

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])

topic Alias on SummarizedColums Year-Montno. in DAX Commands and Tips

Alias on SummarizedColums Year-Montno.

Re: Alias on SummarizedColums Year-Montno.