Please can you assist, I need to change the field "MT NO" in below to return the Month Name and not the Month No.
"YR SEASON CODE" as "Year Season Code",
"MT NO" as "Month",
"WK NO" as "Week No",
"YR NO" as "Year"
Thanks works perfectly.
Let's try as below:
Month( MakeDate(Year, Month, 1) ) as New_Month;
in the UI you can use New_Month as dimension.
Both should do the work:
Retrieving data ...