Forum Discussion

Faye1901's avatar
Faye1901
Helper I
7 years ago
Solved

Date Diff with > 1 condition

Hi All   I've got a relatively simple DAX issue which is elluding me! I'm trying to count the number of days in a given "Stage" of a workflow, I can count the days between stages which are compl...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hey Faye1901 
    You can use a variable.

     

    Time in stage ALL = 
    VAR _StageCompletionDate = IF(StageCompletionDate = BLANK(), TODAY(), StageCompletionDate)

    RETURN
    DATEDIFF('All Workflow Data'[StageEntryDate], _StageCompletionDate, DAY)

    Thanks!
    A



  • Faye1901's avatar
    Faye1901
    7 years ago

    That works perfectly thank you. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey Faye1901 
You can use a variable.

 

Time in stage ALL = 
VAR _StageCompletionDate = IF(StageCompletionDate = BLANK(), TODAY(), StageCompletionDate)

RETURN
DATEDIFF('All Workflow Data'[StageEntryDate], _StageCompletionDate, DAY)

Thanks!
A



Faye1901's avatar
Faye1901
Helper I
7 years ago

That works perfectly thank you.