Forum Discussion

Guneet_B21's avatar
Guneet_B21
Helper II
4 years ago
Solved

Datediff

Hi,

i need to calculate the difference between est date on the first entry of the project vs est date on the last entry of a particular project

and need to show this diff against each project

 

 

 

 

  

Need Help
  • ddpl's avatar
    ddpl
    4 years ago

    Guneet_B21 

     

    Try this,

     

    measure = VAR _min =
    MINX(FILTER(ALL('Table'),SELECTEDVALUE('Table'[Project]) ='Table'[Project] ),'Table'[Est star])

    VAR _max =
    MAXX(FILTER(ALL('Table'),SELECTEDVALUE('Table'[Project]) ='Table'[Project] ),'Table'[Est End])

    Return
    DATEDIFF(_min,_max,DAY)

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Guneet_B21 , A measure like

    Sumx(Values(Table[Project]), calculate(datediff(Min(Table[est date]), Max(Table[EstClose], day)))

     

    • Guneet_B21's avatar
      Guneet_B21
      Helper II
      4 years ago

      amitchandak thanks for this formula,

      it worked, however when i insert the est dates against this difference it sums up to 0

       

  • ddpl's avatar
    ddpl
    Solution Sage
    4 years ago

    Guneet_B21 

     

    Try this,

     

    measure = VAR _min =
    MINX(FILTER(ALL('Table'),SELECTEDVALUE('Table'[Project]) ='Table'[Project] ),'Table'[Est star])

    VAR _max =
    MAXX(FILTER(ALL('Table'),SELECTEDVALUE('Table'[Project]) ='Table'[Project] ),'Table'[Est End])

    Return
    DATEDIFF(_min,_max,DAY)