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 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 .

 

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

     

     

2 Replies

  • 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