Forum Discussion

Sathvikakurli's avatar
Sathvikakurli
Frequent Visitor
2 years ago
Solved

Finding Intersection between two columns

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 fe...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.