To use time intelligence functions in Power BI, you need to have a table that contains at least one column that has a data type of Date. This column should have only one row per day for all the range of dates with no gaps. In other words you need a Calendar Table and don’t forget mark as date table. If you don’t have one use @Melissa Date table is the best.
