Hi.
I have one column named Month Tagged which contains dates from TODAY all the way back to 2012. I have 100K of lines of data with a Month Tagged field on every line.
I do reporting every month for the previous 11 months.
All I want to do is a calculated measure that counts the amount of times each month occurs in the previous 11 months.
dax
So for May 2016 reporting I will want to cont how many time each Month Tagged occur from June 2015 to April 2016.
Any help would be appreciated
I have one column named Month Tagged which contains dates from TODAY all the way back to 2012. I have 100K of lines of data with a Month Tagged field on every line.
I do reporting every month for the previous 11 months.
All I want to do is a calculated measure that counts the amount of times each month occurs in the previous 11 months.
dax
So for May 2016 reporting I will want to cont how many time each Month Tagged occur from June 2015 to April 2016.
Any help would be appreciated