I have a "calendar table" in my Power BI file, which was built with this command:
Calendario = calendar ( date (2015,01,01), today() ).
This returns me a table with a list of all dates between 01/01/2015 and today.
Later on, I began creating the other columns of the calendar table, getting the year of the date ( YEAR ('Calendario'[Date]) ), the quarter of the date ( QUARTER ('Calendario'[Date]) ), and the month of the date ( MONTH('Calendario'[Date]) ).
It worked well, as you can see in the image below (Please be aware that in my example, the columns are using the names in Portuguese for year (Ano), Quarter (Trimestre) and Month (Mes)):
BUT, when I try to use the FORMAT command, Power BI is returning the wrong answer.
I am using FORMAT ( 'Calendario'[Mes], "mmm" ), using the columns that I have just created, but I have tried using
FORMAT ( MONTH('Calendario'[Date]), "mmm" ), referencing the date again. They al give me the same answer, as you can see below:
Any clues on what is going on? Am I doing something wrong?