Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculating case age

Hi,   I have below columns and would like to create a new column Case Age that willl show days the case is open for.   If today is Sep 16 2020 then the Case Age column should show below. If there...
Need Help
  • FrankAT's avatar
    FrankAT
    5 years ago

    Hi Anonymous 

    and here is my final version:

     

     

    Measure = 
VAR _CurrentCreatDateTime = CONVERT(MAX('Table'[CreatDateTime]),DOUBLE)
VAR _CurrentCloseDateTime = MAX('Table'[CloseDateTime])
RETURN
   IF(
        _CurrentCloseDateTime = BLANK(),
        INT(CONVERT(NOW(),DOUBLE) - _CurrentCreatDateTime) ,
        BLANK()
    )

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

FrankAT's avatar
FrankAT
Community Champion
5 years ago

Hi Anonymous 

with a measure you can achieve the expected result like this:

 

 

Measure =
VAR _CurrentCreatDateTime = CONVERT ( MAX ( 'Table'[CreatDateTime] ), DOUBLE )
VAR _CurrentCloseDateTime = MAX ( 'Table'[CloseDateTime] )
RETURN
    IF (
        _CurrentCloseDateTime = BLANK (),
        INT (
            CALCULATE (
                CONVERT ( NOW (), DOUBLE ) - _CurrentCreatDateTime,
                'Table'[CloseDateTime] = BLANK ()
            )
        ),
        BLANK ()
    )

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)