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 Community
Issue
I have a Created column coming in from a SharePoint list and it displays as time and date. I would like to create a custom column that will display 2018 for all dates within 2018 and also another column to display month if possible.
05/08/2015 13:41:19 would ideally become 2015 for example. I'd then like to add a Year slicer to my visual.
I would very much appreciated if someone could help me with this.
Thanks, M
Solved! Go to Solution.
Hi @Anonymous,
I would duplicate the column and then on each one use the built in functions in Edit Queries to extract what you want, month, year etc in each copy of the original column.
Hope that helps!
Matt
Hi @Anonymous,
I would duplicate the column and then on each one use the built in functions in Edit Queries to extract what you want, month, year etc in each copy of the original column.
Hope that helps!
Matt
Thank you very much for this. It worked perfectly.
Easy when you know how 🙂
Proud to be a PBI Community Champion
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 |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |