Hello friends, Hope all is well!
I have two columns in a powerpivot database; each column has two DAX formulas:
The 1st column A: has the following formula:
= CALCULATE(MIN(db[Comdt]),filter(db,db[Employee Status]="Term"),FILTER(db,db[Full Name]=EARLIER(db[Full Name])))
The 2nd column...