Showing 2 tables filtered for different dates (quarters) based on same field

[Anonymous]

Hi,

I am trying to show 2 tables, one showing a given quarter data (10s of columns) as per a slicer selection, the other table (same data) the next quarter. Quarter is decided by a date field which is the same field in each case. The only way I could do it so far is to have 2 different slicers (and associate them independently to the different table) which is not ideal for the user to say the least...

I do use a calendar table connected to my dates to keep everything clean (I don't think it matters but just to be thorough).

I tried to think about measures, hidding a filter that would update based on the other one... but I cannot get to a solution.

Thanks,

David

[v-xuding-msft]

Hi @Anonymous ,

Please try like this:

This Quarter =
VAR Q =
    SELECTEDVALUE ( 'Date'[Qtr] )
RETURN
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        FILTER ( 'Table', 'Table'[Qtr] = Q && 'Table'[Year] = MAX ( 'Date'[Year] ) )
    )

Next Quarter =
VAR Q =
    SELECTEDVALUE ( 'Date'[Qtr] )
RETURN
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        FILTER ( 'Table', 'Table'[Qtr] = Q + 1 && 'Table'[Year] = MAX ( 'Date'[Year] ) )
    )

[Anonymous]

Thanks Xue Ding.

I don't think it will work though.

It's not about the sales value, it is about the individual deals. 

I need to be able to filter on Q2 with a slicer and have one table that shows only Q2 deals (bold) and another table that shows only Q3 deals (Italic). I do not want to sum up, I want to show individual lines... 

Sample raw data:

Deal	Customer ID	Customer name	Close date	Quarter	Product	quantity	Value
123	ABC	Customer1	6/20/20	Q2	Product A	1	100
124	ABD	Customer2	6/15/20	Q2	Product B	2	200
125	ABE	Customer3	8/12/20	Q3	Product C	3	300
126	ABF	Customer4	9/13/20	Q3	Product D	4	400
127	ABG	Customer5	11/9/20	Q4	Product E	5	500
128	ABH	Customer6	10/3/20	Q4	Product F	6	600

I don't think a measure is my way out but happy to be proven wrong...

Thanks,

David