I’m working on a dashboard for a clinic that wants to see the month/year axis as
MM-YY vs MMM-YYYY as defaulted in the Month&Year column in the Extended date table.
Seems like this is a doable thing to add to the extended date table but since I have zero experience in creating M code and though I’ve been pondering the text in the extended table I’m a bit leery of trying to modify the code without a bit of guidance.
Thanks in advance for any guidance or tips before I go down the path of trial & error.
Hmm I must be missing something -
I’m getting an error when adding the column and my google search for the invalid identifier error isn’t helping much… I’m guessing is a minor miss on my part?
thanks
Stubbornness prevails! Figured it out - yes a very small nuance.
Should be:
Date.ToText([Date],“MMM yy”) aka there’s was a misplaced space in the copy/paste I did from your original post.