Forum Discussion

LeonardCs's avatar
LeonardCs
Icon for Helper I rankHelper I
2 years ago
Solved

HELP WITH DAX

Hi all,   I have a table with employee, exam, date of exam and type of exam. I need to program the next exam for each employer. Each employer has to do a new exam past 1 year of the last.   So, ...
Dax Help
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

Hi LeonardCs 

You may try the following calculated column 

next exam =
IF (
'Table'[date of exam]
= CALCULATE (
MAX ( 'Table'[date of exam] ),
ALLEXCEPT ( 'Table', 'Table'[employee], 'Table'[type] )
),
EDATE ( 'Table'[date of exam], 12 )
)

  • LeonardCs's avatar
    LeonardCs
    Icon for Helper I rankHelper I
    2 years ago

    Hey, thank you so much for answer me