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'm new to PowerBI, i'm getting time series data from sql, contains multiple tables. I have to create relation to each tables, only unique column is timestamp. But timestamp differs in milli seconds for each table. So i cannot able to create a relation ,i need to change the date time format to MM:DD:YY HH:MM Please help me to acheive it.
Thanks
Solved! Go to Solution.
You can create a column to transfer the date type. Hope this is helpful. Thanks.
Column = FORMAT(Sheet1[Column1],"DD/MM/YYYY HH:MM")
Proud to be a Super User!
You can create a column to transfer the date type. Hope this is helpful. Thanks.
Column = FORMAT(Sheet1[Column1],"DD/MM/YYYY HH:MM")
Proud to be a Super User!
Thanks a lot for your help sir
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 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |