I have a table in following format
For this table I want to create a Visualization Filter, where Filter should repeat A twice since Id's are different. This Data is coming from different databases. So it is expected.
I have problem when using period time like this : 201301,201302 etc. But when i using formula in powerpivot such as : Sales Previous Month, Sales Month last Year, YTD, MAT. And then after i tried conversion from yymm (201301) to date time (01/01/2013) its works.
See the file for the details...