Data Modelling - Table Function

Power BI Data Model
1

Hi

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.

image
image.jpg1522×835 227 KB

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.

image
image.png1920×888 82.4 KB

image
image.png1700×837 107 KB

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.

image
image.png1647×890 55.2 KB

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