Hello, I have an issue with one tab cube that doesn't sort out a dates in proper order, yet I have another cube that uses the same date dimensions that does. I'm not doing anything special to either one like an order by in the SQL of the view used by the cube. I'd like to get the errant cube to sort the dates properly.
Example, in the cube that isn't quite sorting right, I have two years of data, 2016, 2017, and 2018, and the date values are MM-DD-YYYY. So using Excel connected to the cube, as you scroll through, you'll see it mixed year order like 12/27/2017 then next row 12/27/2016. The other good date cube, no mixing order by date.
Any ideas of how I can tweak the model design to get the aggregated data in the cube to sort the dates out correctly for PBI and Excel users?
Thanks
To add a little more detail, though I am using the same date dim viewes to both cubes, with one sorting out dates just fine, and the other doesn't..., would somehow the date column in the cube not sorting properly is getting the date cast or changed somehow to a text column, and that's why? I'm looking to see if this is the case and not finding that.