Forum Discussion

Yolo_pbi's avatar
Yolo_pbi
Frequent Visitor
2 years ago
Solved

Format function changing the current month to previous month

Hey guys, I am using today function to get the current month, i.e. Month(Today()) which gives me output 2 as for February, but when I use format() to get the full name it changes to January - any ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Yolo_pbi 
    This happens because the current month is not a date datatype, it is just a number. so you always will have it as a January.
    Modify your formula to 

    Current_Month =
    FORMAT(today(),"mmm")

    pbix is attached

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

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi Yolo_pbi 

Please create a measure

 

 

Current Month = FORMAT(TODAY(),"MMMM")

 

 

 


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin