Dax Calculation Help

[RENJITH_R_S]

Hi Friends, Could you please help me to write the dax query for the status column in the below example scenario

if name is already available from previous then status should show already joined, otherwise new joinee 

Input Table
Name	Subject	Date
A	CS	29-01-2021
B	IT	29-01-2021
C	EE	29-01-2021
A	CS	05-02-2021
S	CE	05-02-2021
F	EC	05-02-2021
Output Table
user selects date = 29-01-2021
Name	Subject	Status
A	CS	New Joinee
B	IT	New Joinee
C	EE	New Joinee
user selects date = 05-02-2021
Name	Subject	Status
A	CS	Already Joined
S	CE	New Joinee
F	EC	New Joinee

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[CNENFRNL]

Hi, @RENJITH_R_S , simple enough, you may use date columns as slicer, and a measure

Status = 
IF (
    ISEMPTY(
        FILTER (
            CALCULATETABLE ( Table1, ALL ( Table1[Date] ) ),
            Table1[Date] < MAX ( Table1[Date] )
        )
    ),
    "New Joinee",
    "Already Joined"
)

[RENJITH_R_S · Accepted solution]

Thanks @CNENFRNL .

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[RENJITH_R_S]

thanks @Ashish_Mathur 

[Ashish_Mathur]

You are welcome.