In this video, review the most common date and time DAX functions, including DAY/MONTH/YEAR, HOUR/MINUTE/SECOND, TODAY/NOW, WEEKDAY/WEEKNUM, EOMONTH and DATEDIFF.
- [Instructor] All right, next up we've got…basic date and time functions.…I'm gonna kinda breeze through these,…because all of these should look very familiar.…Most are pretty much identical…to their Excel formula counterparts,…and we've covered a lot of these…in the power query section of the course anyway.…So, just to cover quickly, you've got your component metrics…like day/month/year.…Syntax wise, you just point it to a column…containing a date.…Then you have your time specific versions of those.…You hour/minute/second.…Same deal, you just point it to a column…pointing to a time specific value.…
Course you've got today and now,…the two volatile functions.…Those return the current date…or the exact time respectively,…and syntax wise there really is no component…to those formulas.…It's as simple as open and closed parenthesis.…And then weekday/weeknum.…These will give you a weekday number by default,…starting on Sundays or the week number of the year,…and in this case you've got the optional type…to determine exactly when that week definition starts.…
- Power Pivots versus normal pivots
- Creating calculated columns and measures
- Power Pivot and DAX best practices
- Math, stats, and COUNT functions
- CALCULATE, FILTER, and ALL functions
- Joining data with RELATED
- Using iterator functions (SUMX and RANKX)
- Time intelligence formulas
Skill Level Intermediate
1. Getting Started
Set expectations1m 46s
2. Power Pivot and DAX 101
3. Common DAX Functions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.