Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a telemetry data table called telemetry_augmented, with timestamps (millisecond precision), values and metadata.
From the timestamp column, dp_timestamp, I made a Date-version called dp_timestamp_Date.
dp_timestamp_Date = telemetry_augmented[dp_timestamp]
I made the Data type 'Date' (not Date/time!).
I have a Date table made with this DAX:
Date = ADDCOLUMNS (
CALENDAR (DATE(2020,1,1), DATE(YEAR(NOW()+1),12,31)),
"Date As Integer", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Month Number", FORMAT ( [Date], "MM" ),
"Year Month Number", FORMAT ( [Date], "YYYY/MM" ),
"Year Month Short", FORMAT ( [Date], "YYYY/mmm" ),
"Month Name Short", FORMAT ( [Date], "mmm" ),
"Month Name Long", FORMAT ( [Date], "mmmm" ),
"Day Of Week Number", WEEKDAY ( [Date],2 ),
"Day Of Week", FORMAT ( [Date], "dddd" ),
"Day Of Week Short", FORMAT ( [Date], "ddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"Year Quarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ))
The 'Date' column again is from Data type 'Date'.
There is a relationship between these two Date columns:
Now, I want to filter data based on the Date[Date] column, which kinda works, but I now only get the points with timestamp 00:00 (midnight). This seems strange to me since the types are not Date/time.
The reason I am not filtering directly with the telemetry_augmented table columns is because this is a very big DirectQuery table (to Databricks), and the slicer queries the min(dp_timestamp) and max(dp_timestamp), which takes forever. Filtering on the Date table is faster, but doesn't work correctly as described above.
Thanks in advance for the help.
Having the same issue. Ever find a solution?
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |