Forum Discussion

SEMattis's avatar
SEMattis
Advocate III
2 years ago

[DAX] Format function returning wrong month and date?

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 ...
Need Help
_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

The problem is in you dax formula. You put 

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

 



 

  • SEMattis's avatar
    SEMattis
    Advocate III
    2 years ago

    _AAndrade. Unfortunately, it is still not working

     

     

    • _AAndrade's avatar
      _AAndrade
      Resident Rockstar
      2 years ago

      Please try this formula:


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

       

      • _AAndrade's avatar
        _AAndrade
        Resident Rockstar
        2 years ago

        SEMattis please let me know if your problem was solved.