I am building a calculated column in PowerBI to identify the Month Number.
For Example Jan 2017 will be 1 and Jan 2018 will be 13 and not 1.
To do this, I usually do a calculated column like this :-
MonthNumber = DATEDIFF(Min(Orders[Date]),Orders[Date],MONTH)
But Min function is not supported for Direct Query models. Is there a work around to get the same output in Direct Query.