Forum Discussion

DaniBi92's avatar
DaniBi92
New Member
5 years ago

DATEDIFF with values in different Rows and Fields

Hi, is it possible to use a DATEDIFF formulas with values in different Rows and Fields(or another DAX formulas)? For example, i 've the following Data: ITEM STATUS DATE1         DATE2 XXX...
CALCULATE
DATEDIFF
DAX Commands
Help me
Help Requested
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

DaniBi92 

You can create a DX table with the following code.  Click New Table under the Modeling tab and paste the code given below, rename the table name as per yours.

Result Table = 
ADDCOLUMNS(
    ADDCOLUMNS(
        VALUES(Table1[ITEM]),
        "DATE1", CALCULATE(MIN(Table1[DATE1])),
        "DATE2", CALCULATE(MIN(Table1[DATE2]))
    ),
    "RESULT", DATEDIFF([DATE1],[DATE2],DAY)
)