Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
Hi @Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
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
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |