Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |