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 All,
Good Evening !!!
How to get the month name wiith date( Dec 03,Dec 04,Dec 05......Dec31 ) from the calendar date.
Please see the screen shot
Thanks,
Pratima
Solved! Go to Solution.
Hi @Pratima,
From your description, it seems you want to display the date type column in the format of month name plus day, right?
It depends on which kind of visual you used to represent data. There are three ways:
1. We can set the data format for the date type column below:
2. If you use charts, like line chart, column chart, you can keep the Continues type enabled for X-axis to get expected format.
In charts you can also enable Date Hierarchy, and keep Concatenate Labels enabled.
3. Create a calculated column to return values in the format of month name plus day like below:
Column = FORMAT(MONTH('Table2'[Date]),"MMM") & " " & DAY('Table2'[Date])
Best Regards,
Qiuyun Yu
Thanks Qiuyun Yu ,i got the expected result.....................by using the following function:
Column = FORMAT(MONTH('Table2'[Date]),"MMM") & " " & DAY('Table2'[Date])
Hi @Pratima,
From your description, it seems you want to display the date type column in the format of month name plus day, right?
It depends on which kind of visual you used to represent data. There are three ways:
1. We can set the data format for the date type column below:
2. If you use charts, like line chart, column chart, you can keep the Continues type enabled for X-axis to get expected format.
In charts you can also enable Date Hierarchy, and keep Concatenate Labels enabled.
3. Create a calculated column to return values in the format of month name plus day like below:
Column = FORMAT(MONTH('Table2'[Date]),"MMM") & " " & DAY('Table2'[Date])
Best Regards,
Qiuyun Yu
Thanks Qiuyun Yu ,i got the expected result.....................by using the following function:
Column = FORMAT(MONTH('Table2'[Date]),"MMM") & " " & DAY('Table2'[Date])
@Pratima do you have a date table?
Proud to be a Super User!
Thanks for your valuable time vanessafvg.................
I am having ANY CALENDAR date from that date i am expecting the
Thanks,
Pratima
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |