Return values based on a list in another table

Question

Good day all,&nbsp;I hope I'm posting in the correct place as this is my first time using a community support page. I've looked all over and can't seem to find the answer that I'm looking for and am hoping that someone can help.&nbsp;I have two tables, one containing names and dates (some are repeating values), and another that has just a list of dates. I'm looking to create a table on a dashboard that shows all the dates from the second table and the corresponding names from the first. Basically, I need to display a list of people that match up to specific dates from a list.&nbsp;&nbsp;I used the following to achieve the desired result in excel:=IF(A23='Tracking Table'!$C$1, FILTER('Tracking Table'!A:B,'Tracking Table'!C:C=1),"No")&nbsp;Any and all help is appreciated.

amitchandak · Accepted Answer

Novice_2022 , Join the Table 2 with Table 1 on date and create a measure 
&nbsp;
M1= count(Table1[Name])+0
&nbsp;
and use that in visual with Table 2[Date]
&nbsp;
Or merge the tables in power query , table1, Table2, right join
Merge: https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Forum Discussion

Return values based on a list in another table

2 Replies

Related content

Measure returning incorrect value

Date Different return wrong value

SELECTEDVALUE measure from slicer keeps returning blank value when used on another measure

Vlookup from Another Table Return Value from Column

Return value from another column