List of dates : strange disorder

[GD61]

Hi,

I'm trying to reproduce an example which calculates the growth of sales year by year.

I created a long list of dates in Excel, from January 1st 1999 to 31st December 2015.

When I import that list of dates in Power BI Desktop, the dates arrive in a strange order (see below): so all the calculations are false. What did i miss ?

Thanks

2000
2004
2008
2012
1999
2001
2002
2003
2005
2006
2007
2009
2010
2011
2013
2014
2015

[austinsense]

Best guess is that the dates aren't being recognized as dates - make sure you've explicitly defined the data type.

[greggyb]

Sort order of a table in the Power BI data model does not matter. Can you describe your data model more fully for us and where your date logic calculations are going wrong?