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.
I have a date format like this
Tuesday,25 March,2025
and wanted to convert like YrMth ex: 2025Mar MthYr ex: Mar2015
I tried various options in the formating but couldn't find the way what I wanted as mentioned above.
Thanks,
Hi Thimma,
Have you ttied SabineOussi's solution? I have tested it which works fine. As SabineOussi said, you need to make sure the column is a date format. If it's a string data type, you need to get the year and month from the string manually. We can use Search function, Left and Right function to achieve this requirement.
https://msdn.microsoft.com/en-us/library/ee634235.aspx
https://msdn.microsoft.com/en-us/library/ee634781.aspx
Regards,
Charlie Liao
Try creating theses columns
MthYr = FORMAT(Table[Date], "MMMYYYY")
YrMth = FORMAT(Table[Date], "YYYYMMM")
Where MMM refers to the first three letters of the month and YYYY correspond to the full year.
But first, make sure your Date column is of type Date or Date/Time.
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |