The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Why is a column one data type in Edit Query Mode
Time Difference Column Created in Edit Query Mode
And then changes once you Close and Apply???
Solved! Go to Solution.
So maybe this is just the behavior of how the application works - I'm still curious as to why.
In order to get the same data format as it is in Edit Query Mode -
Change Data Type to: Time
Format to HH:mm:ss
I made the mistake of formatting it to: h:mm:ss tt
However - I'm still curious as to why it switches data types from time to decimal when you close and apply out of Query Mode.
So maybe this is just the behavior of how the application works - I'm still curious as to why.
In order to get the same data format as it is in Edit Query Mode -
Change Data Type to: Time
Format to HH:mm:ss
I made the mistake of formatting it to: h:mm:ss tt
However - I'm still curious as to why it switches data types from time to decimal when you close and apply out of Query Mode.