Forum Discussion
Solved
Annual Average based on Distinct Count
Hi-Power BI community, I need your help. I am trying to look at the average number of people I had for 2019. So far, I was able to get the Distinct Count of their ID by day. When I compare the Av...
Yes
Doing an average of a distinct count is not working for me. What i want to do is get the average count for the year.
ok unless im missing something, would this not work for you?
avg of headcount 2 = AVERAGE(headount[Headcount])