Retrieve Date and Time format from appended queries

Newb10

New Member
Joined
Oct 9, 2019
Messages
7
Office Version
  1. 365
Platform
  1. 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.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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
 
Upvote 0

Forum statistics

Threads
1,213,517
Messages
6,114,085
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top