Average of Distinct Count per Month

[givanova]

Hi all,

I have a table in which I have a column of unique offer ID's. To understand the number of unique offer ID's per day I can create a calculated metric using DistinctCount and the numbers are about correct per daily basis. However, when I want to have the number of offers per month I want to have the 30 days average of each day. 

In this case distinct count only counts the unique offers within a month time. What i need is the average of the distinct offers per month/quarter/year.

How can I solve this?

Thanks!

[v-chuncz-msft · Accepted solution]

@givanova,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Average-of-a-measure-for-each-value-of-the-years/m-p/312310...