DAX: Combine formulas, instead of relying on an idnependant column.

countryfan_nt

Well-known Member
Joined
May 19, 2004
Messages
716
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!
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Watch MrExcel Video

Forum statistics

Threads
1,109,549
Messages
5,529,471
Members
409,884
Latest member
Msinmath
Top