Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
My time and date data exports in one cell "31/03/2017 4:06:07 pm". I need to analyze these seperately i.e. date in one graph and time in another.
Any help appreciated (brand new)
Thanks
PowerBI-Curious
Solved! Go to Solution.
One quick solution would be to create 2 new columns that are the same data as the DateTime column, then make use of the Data Formating to convert one to Time only and the other to Date only.
One quick solution would be to create 2 new columns that are the same data as the DateTime column, then make use of the Data Formating to convert one to Time only and the other to Date only.
Thanks, I just did this 🙂 it worked a treat!
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |