Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
My condition here if one Emp Id have one Login Id then its New if the same EmpId have two LoginId then Old need to show in separate column
Need Calculated column for this condition any help
My Data Is like dis
EmpId | LoginID | Staff Id | Calculation Column |
1 | 768241 | 109099588 | NEW |
1 | 768241 | 109099589 | NEW |
3 | 458996 | 89447383 | NEW |
3 | 458996 | 89447384 | NEW |
7 | 1038397 | 138326615 | OLD |
7 | 1038397 | 138326616 | OLD |
7 | 767451 | 109023218 | OLD |
7 | 767451 | 109023219 | OLD |
7 | 981640 | 130411211 | OLD |
7 | 767451 | 129916202 | OLD |
4 | 475441 | 90549143 | New |
4 | 475441 | 89919587 | New |
4 | 475441 | 89919588 | New |
5 | 461831 | 89599513 | New |
5 | 461831 | 89599514 | New |
Solved! Go to Solution.
please try this
Column = if(CALCULATE(DISTINCTCOUNT('Table'[LoginID]),ALLEXCEPT('Table','Table'[EmpId ]))=1,"new","old")
Proud to be a Super User!
@Venkateswara_ra , Create a new column as
if(countx(filter(Table,[Staff Id] =earlier([Staff Id])),[LoginID])+0=1, "New","Old")
please try this
Column = if(CALCULATE(DISTINCTCOUNT('Table'[LoginID]),ALLEXCEPT('Table','Table'[EmpId ]))=1,"new","old")
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |