Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
(First Post marked as Spam, resubmitting)
Hi all, trying to do something which I think is relatively simple but I can't wrap my mind around it.
These are two sets of data, and then I want to combine into one chart. An example is below.
Set 1 -- this is historical data, but refreshed automatically so on 1/21 I'll get new data that looks similar (ideally with more sites finished)
Site | Date | Finished |
A | 1/15/2020 | 1 |
B | 1/15/2020 | 0 |
C | 1/15/2020 | 0 |
D | 1/15/2020 | 0 |
E | 1/15/2020 | 0 |
A | 1/17/2020 | 1 |
B | 1/17/2020 | 0 |
C | 1/17/2020 | 0 |
D | 1/17/2020 | 0 |
E | 1/17/2020 | 1 |
A | 1/19/2020 | 1 |
B | 1/19/2020 | 0 |
C | 1/19/2020 | 0 |
D | 1/19/2020 | 0 |
E | 1/19/2020 | 1 |
I use the measure below to get me percentage done so far. It shows me 20% for 1/15 and 40% for 1/17 and 1/19.
Site | Date | Finished |
B | 1/21/2020 | 1 |
C | 1/23/2020 | 1 |
D | 1/23/2020 | 1 |
What can I use for a measure that would show me 60% on 1/21 and 100% on 1/23, all on the same chart? Note if I combine the data into one table I have to be careful of future "real" data in Set 1 conflicting with the manual data in Set 2. Also I have the date as a shared CALENDARAUTO() table as shown below.
Thanks in advance!!
You may use CONTAINS to filter the second set first.
I'm sorry, I'm not understanding how the logic would work? What am I searching for with CONTAINS?