Forum Discussion
Efficient Date-Time Table Creation Using DAX
Here is a link to a previous discusson on creating the Date Time Table.
Don't really have the time to answer all your questions right now but the short verison is the time Intelligence features of DAX are amazing and it handles most of the filter contriants and aggregation for you.
Vehicle Volume on Mondays for the 10 Oclock Hour = CALCULATE(SUM(Counts),date[day]="Monday"&&Date[hour]=10)
Just Drop this measure in a chart and add Months or any other field form your date table on the axis and BOOM!!
Good Luck.
Here is a link to a previous discusson on creating the Date Time Table.
Don't really have the time to answer all your questions right now but the short verison is the time Intelligence features of DAX are amazing and it handles most of the filter contriants and aggregation for you.
Vehicle Volume on Mondays for the 10 Oclock Hour = CALCULATE(SUM(Counts),date[day]="Monday"&&Date[hour]=10)
Just Drop this measure in a chart and add Months or any other field form your date table on the axis and BOOM!!
Good Luck.
Thanks again, Seward12533!!!