Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |