Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |