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()...
VizsWork Could you please throw some sample test data and expected output, so that it will be really helpful to suggest an appropriate solution.
| RepMonth | Count |
| Nov-18 | 7 |
| Dec-18 | 6 |
| Jan-19 | 7 |
| Feb-19 | 7 |
| Mar-19 | 6 |
| Average (Sum by month/no of Month) | 7 |
| Distint Month count | 5 |
| Distint Employee count (Incorrect Result) | 10 |