Data Modelling - Table Function


#1

Hi Sam.
On your course on advanced data modelling.
When creating the 2016 Product Budget. On your Dax function you get unique Month Names.
And i get the opposte. and I’m using same DAX as you have.

I am expecting I get unique Product Name and Month Name.
This is really confusing as to why I am not getting January first.
In my Dates Table I’ve also check to see this has been organised by MonthOfYear and this looks correct.

I am happy with my Data Model. 2016 Product Budget. Just not sure about the ordering.
I’ve written the exact same Table function as you have.


#2

Just make sure to bring in the Month Index column as well and sort by that. Should be an easy fix if that is added.

Alternatively you could just create another index in that table with a calculated column