Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |