date limits of 1000 values

[Anonymous]

Hi all,

I am creating a date column to use some quick measures functions. It works quite well, but I realized that I can only include approx. 3 years in this column, since it has a 1000 values limit (and cannot 'skip' dates, has to be continued or it won't work)

After that, the filter simply does not diplay dates anymore therefore. How is this possible ? Any way around this ?

Thank you !

[amitchandak]

@Anonymous , where you faced that limit. how are you creating this table.

[Anonymous]

I created it with the calendar function, but that is not the issue. If I create it with excel and then import it is the same problem. 

[harshnathani · Accepted solution]

Hi @Anonymous ,

Create your Calendar table using the method in this video.

https://www.youtube.com/watch?v=0A5Fbshq6vQ

or you can create your Calendar table reading this article.

https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!