Forum Discussion

rjsidek's avatar
rjsidek
Helper II
6 years ago
Solved

Getting Date Difference between Stages in the same column

Hi everyone,

 

I currently have a sample dataset that looks like this:

 

What I am trying to achieve is this:

 

I am looking to create a measure that tells me how long it takes for the "Project Stage" column to move from one stage to another. I believe that I have to use the DATEDIFF function somehow but I am not yet able to do it. 

 

For example, I want to be able to see the time it takes for the company to move from stage 1 to stage 2.

 

Any help would be appreciated and thanks in advance!

Need Help
  • az38's avatar
    az38
    6 years ago

    rjsidek 

    how it should look if no one slicer is chosen?

    anyway, try a measure

    Measure = 
var SecondStage = 
calculate(min('Table1'[Date]);ALLEXCEPT('Table1';'Table1'[Company];Table1[Stage]))
var Init = calculate(max('Table1'[Stage]);ALLEXCEPT('Table1';'Table1'[Company]);'Table1'[Date]<SecondStage;'Table1'[Stage]<>"")
var InitialStage = if(isblank(Init);SecondStage;calculate(min('Table1'[Date]);FILTER(ALL('Table1');'Table1'[Company]=SELECTEDVALUE(Table1[Company])&&'Table1'[Stage]=Init)))
RETURN
DATEDIFF(InitialStage; SecondStage; DAY)

    do not hesitate to give a kudo to useful posts and mark solutions as solution

8 Replies