topic Re: Changing hours of day in DAX Commands and Tips

Changing hours of day

amandabus21 — Tue, 28 Feb 2023 17:43:53 GMT

How can I change my 24"day" to be from 4:30AM - 4:29AM. (So not, 12:00AM - 12:00AM)

My Date/Time column is : "Date and Time"

Column/ Measure preffered please.

tamerj1 — Tue, 28 Feb 2023 17:48:50 GMT

Please provide an example

amandabus21 — Tue, 28 Feb 2023 18:00:59 GMT

In this example, I am calculating the mileage on one given day. However, Power BI is picking up the day from 12:00AM to 12:00AM.

Our day starts at 4:30AM and ends at 4:29AM the next day. I'd like the slicer to calclaute 1 day as 4:30AM- 4:29AM.

tamerj1 — Tue, 28 Feb 2023 18:19:06 GMT

But how does your data look like and from which table/column does the date slicer come ftom?

amandabus21 — Tue, 28 Feb 2023 20:13:58 GMT

Date Slicer is from Table: Bus Notification & Mileage: Date and Time

here is the rest of the breakdown

FreemanZ — Wed, 01 Mar 2023 05:56:26 GMT

Again, how does your data look like?

amandabus21 — Wed, 01 Mar 2023 17:21:32 GMT

FreemanZ like the data types?

FreemanZ — Thu, 02 Mar 2023 02:06:07 GMT

try to make a screenshot of the data table containing the relevant columns