PROBLEMS WITH DATES AND DATE TABLES

Question

Hello everybody, I'm having some difficulty with the report I'm creating right now. The problem is that in my data I have the production made in a factory per shift. Example:Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Operator&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Production&nbsp; &nbsp; &nbsp; Shift01/01/2019 00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Mark&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A01/01/2019 08:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Mark&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B01/01/2019 16:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Mark&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp;Since I have multiple tables I created a date table in order to being able to filter through data in the report relative to the date, however in this date table I have only dates like 01/01/2019 00:00 , because of that in all my visualizations the only data I can filter relative to date is that from Shift A. Any ideas how I could work around this proble?&nbsp;&nbsp;

dax · Accepted Answer

Hi EduardoPach,&nbsp;
I am not sure whether you want to create a calendar table which duration is one hour or you want to change datetime to date?
If you want to create datetime calendar table, you could try below M code
let
    Source = List.DateTimes(#datetime(2019, 01, 01, 00, 00, 0), 1000, #duration(0, 1, 0, 0)),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
    #"Converted to Table"
You could refer to&nbsp;List.DateTimes&nbsp; for details.
If you want to change datetime to date, you could right click column to change type-&gt;date in Edit Queries for both calendar and fact table.
&nbsp;
Best Regards,Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

Forum Discussion

PROBLEMS WITH DATES AND DATE TABLES

2 Replies

Related content

Date Function Problem

Date Slicer not Responsive to Calculated Date Table

Stuck with Date Problem

Logic problem?

COUNTROWS using date problem