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,
I have a date column in my metadata in simple date format.
How can I format it to be shown as below. I want it to be shown as Month'Year format in sorted manner.
Please Note: I'm using direct query mode so cant use format option.
Regards,
Himanshu
Anyone has a idea how to format a simple date to"YYYYMM"
format in direct query?
This will resolve my issue.
Hi @Anonymous
You can add below format in custom formatting to get your desired output.
Thanks
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
I'm getting this output
How to get month wise break up like below:
You can create two calculated column one for format your date and another column for sorting of your formatted date column. Below are the required code for both format and sort date column.
formatted_date = FORMAT(date_table[Date],"MMM YYYY")
Sort = FORMAT(date_table[Date], "YYYYMM")
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
@Samarth_18 Yes this is easy and can be done when in import mode but format doesnt work in Direct query mode hence facing this issue.
I have created the Month'Year using concat but sorting is the issue. Sorting is not happening correctly for me.
Hey @Anonymous ,
why not? Custom format works also in DirectQuery mode, I just tried it:
And the storage mode is DQ:
I want to present the data in the below format, can you please help me with the steps how to use it as its not working for me at the moment.
Its showing me very incorrect data.
It should be something like below , i have created some calculated column n done concat but sorting is not working properly.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |