Forum Discussion

rajesh2001's avatar
rajesh2001
Advocate I
9 years ago
Solved

Using Slicer to Ge data for Rolling 3 Months

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 Val...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    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

     

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

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's avatar
rajesh2001
Advocate I
9 years ago

Thanks a lot Dale . This solution helps