Help on calculating cumulative of distinct count of suppliers for rolling 12 month Period

[#1]

Hi All,

I need to calculate the cumulative distinct count of suppliers over last 12 months. It should be from 2016 August to this year August month. Anyone have any idea on this?

Regards,

Smruti

[sunny_talwar]

Best way to do this would be to use The As-Of Table