Create Relationship between slicers and table

[jiinson]

Hi, 

I'm trying to work out making relationship between these slicers and my big table. I have made the table to make those slicers.

The big table, which has a huge amount of data, includes order date and customer name, customer city, the amount of USD etc.

I want to make the relationship between the slicer and my big table so that every time I choose the filter, the report changes simultaneously.

I have already made date table which includes date from 1/1/2005 to 12/31/2017, month no, day, year, halves, quarter, Mon YTD.

Maybe I need or change a table to make relationship between those three tables(date, big table, mode time table). Any idea would be appreciated.

Thanks in advance!

[Greg_Deckler · Accepted solution]

If I am understanding what you are trying to accomplish, I'm not sure you can go about it exactly that way. You would almost need to have an actual date tied to that Time Mode table that you could then pass into your Time Intelligence function or formula so that would set the appropriate parameter value in the function. I'll try to think about how you could accomplish what you are trying to accomplish.