Rolling measure for two columns

[devGV_88]

Hi folks!

I need to count rows rollling 12 month.

I was able to create the measure a show by month.

Measure: CALCULATE(DISTINCTCOUNT(Table[ID]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-12,MONTH))

But when I add onw more collumn (Vendor) from the same table I see other result.

I need the rolling in the last table to show as chart.

Could you help me?

[devGV_88]

Hi all!

Any idea?

[devGV_88]

@Greg_Deckler Thanks.

I was able to calculated the simple rolling showing the moth (like the first screenshot in my post).

My problem is when I add on more collumn in the table or chart.

[Greg_Deckler]

@devGV_88 https://community.powerbi.com/t5/Quick-Measures-Gallery/Rolling-Months/m-p/391499#M124