Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am accessing Redshift data via direct query (not loading the data as the update cycles are hourly). The date is in a timestamp format in the originating table.
How can I separate the date from the date timestamp. All of the DAX commands I use are assuming that the field is text based, but the timestamp format is a value. Any help is greatly desired.
The reason for the questions is I am trying to get the count of id's that were active between two dates. When there are duplicate date times within the dataset it throws an error. I've tried two different approaches but neither works due to the timestamp issue. See the two different approaches below
1.
The second formula was cut off:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |