Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
99 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |