Return a list of value match the specific time period

[Anonymous]

Hi everyone,

I need your help! I want to get a list of value from a column that matches specific time period in the same table.

Below is my table, it contains the sales data since 01/01/2016.

I want to get a list of [EIDCodeBoutique], whoes [DateVentes] corresponds Yesterday;

And another list of [EIDCodeBoutique], whoes [DateVentes] is between 27/08/2018 and Today.

How can i achieve this? 

Best Regards,

Chen

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[Stachu · Accepted solution]

try this

Measure = 
VAR YesterdayOnly = FILTER('Table','Table'[DateVentes]=TODAY()-1)
VAR OtherTime = FILTER('Table','Table'[DateVentes]<TODAY() && 'Table'[DateVentes]>=DATE(2018,8,27))
RETURN
CONCATENATEX(DISTINCT(YesterdayOnly),'Table'[EIDCodeBoutique],",")

for your second measure replace YesterdayOnly in DISTINCT with OtherTime