[DAX] Format function returning wrong month and date?

[SEMattis]

Hi,

So I have a problem with the formatting function which could be error 45 (I.e. yours truly) or something really interesting is happening in Power BI. When using the following syntax:

VAR Prev_M = MONTH((TODAY())) -1 

It returns 1. However when setting the variable in the FORMAT function and converting the date to a month name the measure returns "December" (See images below).

Need some help 😄

[Anonymous]

Hi @SEMattis 

How about  FORMAT(TODAY(),"MMM") ? Perhaps MOTH function is messing up something .
Thanks !

[SEMattis]

Well this would not work since I am dependent on months in the past to solve my problem. Good idea though.

[Anonymous]

I'am having the same problem. It is terrible.

[_AAndrade]

Open a new ticket with your problem and I will take a look

[_AAndrade]

Tell me what you want to show on the visual and I will give you the correct dax function.

[SEMattis]

So I want the FORMAT function to return "December" rather than January

[SEMattis]

And perhaps even more worrying? 

[_AAndrade]

The problem is in you dax formula. You put 

And you must put -1 inside parantesis. like this:

[SEMattis]

@_AAndrade. Unfortunately, it is still not working

[_AAndrade]

Please try this formula:

I think it's what you're looking for.

[_AAndrade]

@SEMattis please let me know if your problem was solved.

[SEMattis]

Sorry but I have tried this too without success

[_AAndrade]

Please send me a picture with the output that you're looking for, because I don't understand yet what are the problem