Learn why marking a Date dimension as date table is critical to use DAX Time Intelligence functions

preview_player
Показать описание
#POWERBI #MICROSOFT #MICROSOFTPOWERBI #DAX #MICROSOFTPOWERBIDATAANALYSIS, #DATAANALYSIS, #BUSINESSINTELLIGENCE #BI #PERYTUS #DECIPHERYOURDATA #TIMEINTELLIGENCE #DAX #DAXTIMEINTELLIGENCEFUNCTIONS #DATEADD #DATESMTD #MONTHTODATE #DAXMTD #DAXQTD #DAXYTD #MTD #YTD #QTD #RELATIVEDATEFILTER

This is the 9th video on DAX Time Intelligence functions. In this video, we will explore why setting a Date/Calendar dimension as "Mark as Date Table" is important. How the time intelligence functions will give different results if a Date dimension is not marked as a date table. Also, we will explore how to use the current date as a default date if no value is selected in the slicer.

Рекомендации по теме
Комментарии
Автор

This is amazing production really. But I am wrestling to figure out why are you using the MAX() function too?

lifeisgreat