Retrieve Date and Time format from appended queries

Newb10

New Member
Joined
Oct 9, 2019
Messages
4
Office Version
365
Platform
Windows
Hello,

I am new with PowerBI and not sure if this is even possible.

I have a main table/data model which I appended multiple months of data (different tables per month, which I append tables per month). A column on the data model had originally a Date and Time format which I changed the format to Date only (this is the only format I used for a couple of months now). I then unchecked the "Enable Load" on the previous months which I did not realize that there would come a time that I would need to have the time along with the date to measure the time interval.

Steps I have tried to retrieve the data :
1. I have tried to change the format to Date and time in the data model but it only gives me 12:00:00 on all rows.
2. I have checked the "Enable Load" then refresh power query and the main page, but it is still showing 12:00:00
3. I tried deleting the steps of "change type" on the applied steps on the power query, but no good.
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello,

First thing is to make sure you are dealing with Values ... and not Text ...

You can see Dates and Times ... but the display is misleading ...

Hope this will help
 

Forum statistics

Threads
1,084,838
Messages
5,380,198
Members
401,654
Latest member
etusch

Some videos you may like

This Week's Hot Topics

Top