Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all,
I have attached the document. Can some one help me change the date format to
E.g from January 10, 2019 to Jan 10, 2019 (Only use the short writing of month)
Thank you!!!
https://1drv.ms/u/s!ArC4uvMBwvXvgQviVd3c7Vnf2BrA?e=TJmFtw
https://1drv.ms/x/s!ArC4uvMBwvXvgQrsq_rI1BFX9CrR?e=d0IWYG
Solved! Go to Solution.
Hi @xiumi_hou ,
We can change the custom format as mentioned in this similar thread: https://community.powerbi.com/t5/Desktop/How-to-create-a-new-column-and-display-the-date-format/td-p...
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @xiumi_hou ,
We can change the custom format as mentioned in this similar thread: https://community.powerbi.com/t5/Desktop/How-to-create-a-new-column-and-display-the-date-format/td-p...
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can add a calculated column to your table with this code.
Formatted Date = FORMAT(Sheet2[session_date],"mmm d, yyyy")
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |