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 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
User | Count |
---|---|
90 | |
73 | |
68 | |
63 | |
56 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |