countryfan_nt
Well-known Member
- Joined
- May 19, 2004
- Messages
- 765
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: Comdt has the following formula:
=FORMAT([Month]&"-"&[Year],"00000")
I want to eliminate/delete column Comdt and get rid of it, but I want the results to appear in formula of Column A.
i.e. I want to combine the formulas (replace the 2nd formula with word comdt in the 1st formula.
= CALCULATE(MIN(db[Comdt]),filter(db,db[Employee Status]="Term"),FILTER(db,db[Full Name]=EARLIER(db[Full Name])))
Plus
=FORMAT([Month]&"-"&[Year],"00000")
Please help and thanks a Lot! In advance!
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: Comdt has the following formula:
=FORMAT([Month]&"-"&[Year],"00000")
I want to eliminate/delete column Comdt and get rid of it, but I want the results to appear in formula of Column A.
i.e. I want to combine the formulas (replace the 2nd formula with word comdt in the 1st formula.
= CALCULATE(MIN(db[Comdt]),filter(db,db[Employee Status]="Term"),FILTER(db,db[Full Name]=EARLIER(db[Full Name])))
Plus
=FORMAT([Month]&"-"&[Year],"00000")
Please help and thanks a Lot! In advance!