Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Best guess is that the dates aren't being recognized as dates - make sure you've explicitly defined the data type.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |