Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
BeaBF
Super User
Super User

DYNAMIC SEARCH STRING

 

Hi!
I have two identical tables, the second (Table B) is the copy of the first (Table A) and a third table of distinct values ​​of the two, related to both tables.
I created a slicer for each of the two tables A and B which filters the date.

What I would like to do is check if the record in "ITEM" field, by selecting two different dates on the two tables, is present in both or only in one of the two. 

In short, if the record of the "ITEM" field between the two selected periods remains or is no longer present, since one table is the copy of the other.

 

Thx,

B.

2 REPLIES 2
BeaBF
Super User
Super User

@smpa01 

 

bf_1-1636126394924.png

 


Tables A and B are identical. ITEM1 is native to the table, ITEM2 instead is taken from the Distincts Table. In fact, the Distincts table is a table of distinct values ​​of Table A / B, enriched with the ITEM2 field, then related to both tables. On each of the two tables A and B there is a Slicer on the date. As you can see by filtering the slicers on two different periods, the data in Table A or B may no longer be present or change for the ITEM2 field, ITEM1 is not important. I would like a single table that would show all those records that filtering the two slicers changes from Table A to Table B for the ITEM2 value. So in this case, i would like to show only the first row of Table A, that has disapperead in Table B.

smpa01
Super User
Super User

@BeaBF  provide some sample data.

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.