Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Power bi experts,
I need to find out Termination date in below table,i have 3 records (i.e Action Type - D1, EE,ES this are employees last date )
i need these three data in the separate Termination Column, could you please suggest a calculated column and also need to aplly filter Action Type {"D1", "EE","ES"}
my output will like
Solved! Go to Solution.
Please try
Termination Date =
VAR CurrentDate = TableName[Action Date]
VAR TerminationDate =
CALCULATE (
MAX ( TableName[Action Date] ),
ALLEXCEPT ( TableName, TableName[Emp.No] ),
TableName[Action Type] IN { "D1", "EE", "ES" }
)
RETURN
IF ( CurrentDate = TerminationDate, TerminationDate )
Please try
Termination Date =
VAR CurrentDate = TableName[Action Date]
VAR TerminationDate =
CALCULATE (
MAX ( TableName[Action Date] ),
ALLEXCEPT ( TableName, TableName[Emp.No] ),
TableName[Action Type] IN { "D1", "EE", "ES" }
)
RETURN
IF ( CurrentDate = TerminationDate, TerminationDate )
@MahamoodBi
Seems you have two fact tables. Please provide details about yuor data model and relationships.
User | Count |
---|---|
50 | |
24 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
21 |