Earn 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!
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |