DAX Time Intelligence Functions
Budget: $15 – $20 CAD
Requests
1. Create a date table with dates, hours and seconds and make a connection with the temperatures by Date and Time Table
2. Create a measure that shows the max temperature by City in the last 3 days (current date is not included) for the Temperature by Date table
3. Create a measure that shows the temperature by City for the prior day for the Temperature by Date table
4. Create a measure that shows the max temperature by City in the last 3 timestamps (current timestamp is not included) for the Temperature by Date and Time table
5. Create a measure that shows the temperature by City for the last timestamp for the Temperature by Date Time table
6. Create a measure that shows the max temperature by City in the timestamps of the last 90 minutes (current timestamp is not included) for the Temperature by Date and Time table
1. Create a date table with dates, hours and seconds and make a connection with the temperatures by Date and Time Table
2. Create a measure that shows the max temperature by City in the last 3 days (current date is not included) for the Temperature by Date table
3. Create a measure that shows the temperature by City for the prior day for the Temperature by Date table
4. Create a measure that shows the max temperature by City in the last 3 timestamps (current timestamp is not included) for the Temperature by Date and Time table
5. Create a measure that shows the temperature by City for the last timestamp for the Temperature by Date Time table
6. Create a measure that shows the max temperature by City in the timestamps of the last 90 minutes (current timestamp is not included) for the Temperature by Date and Time table