Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello teams,
I use "Month(Now()) to get the current month and I get "11" for this month. But I want to convert number to character (Novemeber instead of 11)
Solved! Go to Solution.
@Anonymous
Give this a try
Current = FORMAT(NOW(), "MMMM")
The problem you are running into is the way DAX (and excel and SQL etc.) think of dates.
NOW() is really 43784 which is the numeric value of 11/15/2019.
When you say MONTH(NOW()) you are getting 11 which DAX reads as the date 1/11/1900 so it formats "MMMM" as January.
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
Try
Month(Now()) & ""
Current = FORMAT(MONTH(NOW()), "MM")
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
@Anonymous
Give this a try
Current = FORMAT(NOW(), "MMMM")
The problem you are running into is the way DAX (and excel and SQL etc.) think of dates.
NOW() is really 43784 which is the numeric value of 11/15/2019.
When you say MONTH(NOW()) you are getting 11 which DAX reads as the date 1/11/1900 so it formats "MMMM" as January.
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
User | Count |
---|---|
94 | |
79 | |
73 | |
63 | |
59 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |