Forum Discussion
DAX for empty date column
Hi, I have a data set with a date column (DD.MM.YYYY), a year column and a quarter column. I want to primarily use the date column for time intelligence. However, some rows in the date column ...
Anonymous
If you have blank rows in your date table than this is not a proper date table and you won't be able use time intelligence with it. You need to clean your data before you bring it to the model.
Check this for a good reference for a simple date table:
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/