Calculate the distinct count in previous month

[datanau001]

Dear all,

I've been trying to create a new measure to show the distinct count of values in the previous month but haven't had success.

The reason for this, is to use the previous month to calculate the increase in percentual through the months.

The data is based in a month column with the following values:

Close Month	SR Number
2018\01	842
2018\02	718
2018\03	954
2018\04	862
2018\05	1121
2018\06	1151
2018\07	1348

Would you please help me with this question?

Thank you 

[v-danhe-msft · Accepted solution]

Hi @datanau001,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[datanau001]

Hello Daniel,

The problem has been solved with your instructions.

Thank you

Marcello

[v-danhe-msft]

Hi @datanau001,

Based on my test, you could refer to below measure:

Measure = var a=PREVIOUSMONTH('Table1'[Close Month])
return CALCULATE(SUM(Table1[SR Number]),FILTER(ALL('Table1'),'Table1'[Close Month]=a))

Result:

Regards,

Daniel He