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.
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")
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |