cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GD61 Member
Member

List of dates : strange disorder

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 ? Smiley Sad

Thanks

2000
2004
2008
2012
1999
2001
2002
2003
2005
2006
2007
2009
2010
2011
2013
2014
2015
2 REPLIES 2
austinsense Established Member
Established Member

Re: List of dates : strange disorder

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

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast Smiley Happy
greggyb New Contributor
New Contributor

Re: List of dates : strange disorder

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?

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 448 members 4,769 guests
Please welcome our newest community members: