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.
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:
Need some help 😄
Hi @SEMattis
How about FORMAT(TODAY(),"MMM") ? Perhaps MOTH function is messing up something .
Thanks !
Well this would not work since I am dependent on months in the past to solve my problem. Good idea though.
I'am having the same problem. It is terrible.
Open a new ticket with your problem and I will take a look
Proud to be a Super User!
Tell me what you want to show on the visual and I will give you the correct dax function.
Proud to be a Super User!
So I want the FORMAT function to return "December" rather than January
And perhaps even more worrying?
The problem is in you dax formula. You put
And you must put -1 inside parantesis. like this:
Proud to be a Super User!
Please try this formula:
I think it's what you're looking for.
Proud to be a Super User!
@SEMattis please let me know if your problem was solved.
Proud to be a Super User!
Please send me a picture with the output that you're looking for, because I don't understand yet what are the problem
Proud to be a Super User!