Forum Discussion
Dax Optmisation
Hi All Help!!!!! How can I make this dax code faster its too slow and i dont like it HeadCount 12M (ColleagueType) = VAR MonthSelected = SELECTEDVALUE(Calender[End of Month],EOMONTH(UTCTODAY()...
It might be helpful to tell people what the code actually does or should do. This way not everybody needs to go through it.
I want to be able to do a monthly distinct count of employee number for any year and so I can calculate the average employee for the year.
To archive this, I created a summarized table and grouped it by month with each row contain the distinct employee for the month after which I summed each row to give me the year totalthanks your reply
