Create two list from same parent table with difference conditon.

Dear AshishTanwar88 ,

Try below steps:

Load the Data:

Load the source table into Power BI.

 

Create Two Date Slicers:

Add a slicer for AttendanceDate in the Power BI report. Duplicate this slicer to create two independent slicers for Date Filter 1 and Date Filter 2

 

Create Calculated Tables:

Use DAX to create two calculated tables for Result Table 1 and Result Table 2.

DAX for Result Table 1

This table includes employees present on Date Filter 1 but absent on Date Filter 2:

ResultTable1 = 
VAR FilterDate1 = SELECTEDVALUE(SlicerTable1[AttendanceDate])
VAR FilterDate2 = SELECTEDVALUE(SlicerTable2[AttendanceDate])
RETURN
FILTER(
    MainTable,
    MainTable[AttendanceDate] = FilterDate1 &&
    NOT(MainTable[Em ID] IN 
        CALCULATETABLE(
            VALUES(MainTable[Em ID]),
            MainTable[AttendanceDate] = FilterDate2
        )
    )
)

DAX for Result Table 2

This table includes employees present on Date Filter 2 but absent on Date Filter 1:

ResultTable2 = 
VAR FilterDate1 = SELECTEDVALUE(SlicerTable1[AttendanceDate])
VAR FilterDate2 = SELECTEDVALUE(SlicerTable2[AttendanceDate])
RETURN
FILTER(
    MainTable,
    MainTable[AttendanceDate] = FilterDate2 &&
    NOT(MainTable[Em ID] IN 
        CALCULATETABLE(
            VALUES(MainTable[Em ID]),
            MainTable[AttendanceDate] = FilterDate1
        )
    )
)

Add the Tables to the Report:

• Use a table visual in Power BI to display the data from Result Table 1 and Result Table 2.

• Customize the Report:

Add titles and labels to clearly indicate what each table represents.

Result

• Result Table 1: Displays employees present on Date Filter 1 but absent on Date Filter 2 (e.g., Martin)
• Result Table 2: Displays employees present on Date Filter 2 but absent on Date Filter (e.g., Lora)

 

Please mark this as solution if it helps you. Appreciate Kudos.

Hi,

Share data in a format that can be pasted in an MS Excel file.