Forum Discussion

devGV_88's avatar
devGV_88
Icon for Helper I rankHelper I
4 years ago

Rolling measure for two columns

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?