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?