Using Slicer to Ge data for Rolling 3 Months

[rajesh2001]

Hi All,

I have a requirement where when the user selects a particular Fiscal period like FY 17 - Q1 , it should automatically get the previous 2 quarters data with the current one 

Slicer Value Selected : FY17-Q1

Data To be Shown:

Fiscal Qtr   Revenue

FY16 Q3  - 100$

FY16 Q4  -  80 $

FY17 Q1  - 90 $

Our calendar is a customized calendar and does not start on the first day of every month for each fiscal period .

Any help is appreciated  

I have tried different options but came up blank in acheiving this .

[v-jiascu-msft · Accepted solution]

Hi @rajesh2001,

I think we need to create two tables in this scenario. The tables look like this:

The bridge table could use this formula:

BridgeTable = values(ForSlicer[column2])

Finally, create relationships(the direction should be "both"). ForSclier->BridgeTable->Calendar.

Please refer to this post: problem-with-calculation-many-to-many. It's almost the same with yours.

Best Regards!

Dale

[rajesh2001]

Thanks a lot Dale . This solution helps