Help needed table with 2 comparison columns - 2 slicers needed to operate the dates independently

[Anonymous]

Outcome	Distinct Count of period 1	% period 1	Distinct Count of period 2	% Period 2
Outcome 1
Outcome 2
Outcome 3
Outcome 4
Outcome 5

The outcome is a Distinctcount of the product ID.

Two date slicers would be needed to aid the users to operate the comparison periods between 1 and 2.

Can anyone help me do this?

[v-yulgu-msft]

Hi @Anonymous,

Please provide some sample data in source dataset and show us your expected output.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu

[Greg_Deckler]

One way to do this is to have two disconnected Calendar tables. A slicer is tied to each one but these slicers do NOT filter anything on the page. You then construct measures such that they start out with something like:

Measure = 
VAR __date1 = MAX(Calendar1[Date])
VAR __date2 = MAX(Calendar2[Date])
...

You can then base your calculations on these VAR's. This might also help:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[Anonymous]

Thanks for the reply.

I need the two slicers for example have the ability to show the data in the table from the outcomes by operating the first slicer in say Period 1 date point x and y to slicer Period 2 date point x and y.

Can you help?