Select values from different columns depending on the dates selected

[giorgiokatr]

my table is like that

date (close of month)	Sales	Unique Customers	Unique Customers 3M	Unique Customers 6M	Unique Customers 12M
29/1/2016	314	79	257	594	786
29/2/2016	460	115	257	594	786
31/3/2016	380	95	257	594	786
28/4/2016	360	90	476	594	786
31/5/2016	896	224	476	594	786
30/6/2016	1056	266	476	594	786
29/7/2016	316	79	283	480	786
31/8/2016	408	102	283	480	786
30/9/2016	572	143	283	480	786
31/10/2016	412	103	290	480	786
30/11/2016	708	177	290	480	786
14/12/2016	62	18	290	480	0

I would like when i select one month to have the values of Unique Customers.

When a user selects a quarter (Q1, Q2, Q3, Q4) ( to have the values of 3M, when selects YTD to have the values of 12M

If users selects months that are not in a quarter (Q1, Q2, Q3, Q4) (eg 29/2 - 31/3 - 28/4) maybe a blank value?

for one month selection is quite simple

IF(DISTINCTCOUNT('mytable'[date])=1;SUMX('mytable';'mytable'[Contacts unique clients]);"")

Any ideas?

[tringuyenminh92 · Accepted solution]

Hi @giorgiokatr,

I think there are some topics that covers guideline to implement dynamic slicer as your description:

• https://community.powerbi.com/t5/Community-Blog/Dynamically-change-the-information-within-a-visual-v...
• http://community.powerbi.com/t5/Data-Stories-Gallery/Create-Dynamic-Periods-for-Fiscal-or-Calendar-D...
• https://community.powerbi.com/t5/Desktop/Time-selector/td-p/96513

[giorgiokatr]

Thanks! Very helpful!