how to capitalize the months present in the time table?

[Anonymous]

Hello,
How to put a capital letter in the time table? I tested with the DAX Upper(Left) code but it doesn't work. Can you help me? Thanks. G.

Here is the original dax code:

ADDCOLUMNS(CALENDAR(DebDate,FinDate),
"Annee", FORMAT([Date],"YYYY"),
"Trimestre" , "T"&FORMAT([Date],"Q"),
"Numero du mois", MONTH([Date]),
"Mois", "M"&FORMAT([Date],"M"),
"Annee mois", FORMAT([Date],"YYYYMM"),
"Nom du mois", FORMAT([Date],"MMMM YY") ,
"Nom court du mois", FORMAT([Date],"MMM YY") ,
"Semaine" , "S" & FORMAT(WEEKNUM([Date],2),"00"),

[Anonymous]

Hi @Anonymous ,

It's strange that you have mentioned using UPPER, but please try the following expression again:

ADDCOLUMNS(
    CALENDAR(DebDate, FinDate),
    "Annee", FORMAT([Date], "YYYY"),
    "Trimestre", "T" & FORMAT([Date], "Q"),
    "Numero du mois", MONTH([Date]),
    "Mois", "M" & FORMAT([Date], "M"),
    "Annee mois", FORMAT([Date], "YYYYMM"),
    "Nom du mois", UPPER(FORMAT([Date], "MMMM YY")),
    "Nom court du mois", UPPER(FORMAT([Date], "MMM YY")),
    "Semaine", "S" & FORMAT(WEEKNUM([Date], 2), "00")
)

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for this answer, but this doesn't work.

[mark_endicott]

@Anonymous - Adding this to your DAX should work:

"Month", FORMAT( [Date], "MMMM")

Screenshot shows it's working below:

Please accept this as the solution if it works for you. 

[Anonymous]

Thanks for your feedback, but it doesn't work on my pc 😞

[mark_endicott · Accepted solution]

@Anonymous - then this must be in your Power BI settings somewhere. I would raise a Support ticket for this rather than asking on a DAX Forum. You can do that here: https://admin.powerplatform.microsoft.com/newsupportticket/powerbi 

I have supplied the answer in DAX so if you could accept it as the solution for others that would be great. 

[Anonymous]

Thanks for the advice!