Finding Intersection between two columns

[Sathvikakurli]

How do I find the intersection between empId's based on baseline month(both Columns from one table) .
Example: here 783746 this employee have Dec, Jan and Feb months if i select baseline month as feb have show only this employee

EmpID's	Baseline month
456476	Jan 2024
783746	Feb 2024
835575	Jan 2024
635466	Dec 2023
836475	Dec 2023
735497	Jan 2024
646557	Jan 2024
783746	Jan 2024
635466	Feb 2024
456476	Feb 2024
783746	Dec 2023

[v-jianpeng-msft · Accepted solution]

Hi, @Sathvikakurli 

You can use slicers and table visuals to select a month and display the employees for that month. Based on your data:

You need to create a slicer and put the month in BaseLine month into the field of the slicer (if Month is not found in your BaseLine month, you need to open the Date hierarchy as shown below):

Place EmpID's, Baseline month in the columns of table visual:

Click on a month through the slicer, and the table visual will display the EmpID's of the corresponding month.

You can also define more advanced filtering capabilities in the Filters sidebar. If the above tips help you, that's great.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.