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.
Hello, I want to create a column where it only has Month, Year instead of my current DATE (image below) . I tried spliting and even creating a new column and it is not working. I want to keep my current Date I have, however I want to create a new column that only has Month, Year.
Hello,
I know this is quite an old post but for any that are looking for this answer at the time of this reply, how I was able to achieve this was by adding a new Custom Column for the result in the format "mm-yyyy":
New_Column_Name
= DateTime.ToText([field_name], "mm") & "-" & DateTime.ToText([field_name], "yyyy")
The "-" can be replaced with any symbol you want to divide the month and year.
In my case I wanted the result to be the full month name and abbreviated year (ex: September '19). How I achieved this:
New_Column_Name
= Date.MonthName([field_name], "optional_culture") & DateTime.ToText([field_name], "yyyy")
Please keep in mind that because this new column is Text, they will be sorted alphebetically and not chronologically. To sort the new column chronologically: When in Report View, select the newly created field in your Fields Pane, then select Sort by Column button in the Modeling ribbon and choose the initial [field_name] used to create this new column (in your case Date Given).
Hope this helps!
In DAX that would be:
MonthYear = FORMAT([Date Given],"mm, yyyy")
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |