Datediff

[Guneet_B21]

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

[ddpl · Accepted solution]

@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)

[Guneet_B21]

Thanks alot,

this is working

[amitchandak]

@Guneet_B21 , A measure like

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

[Guneet_B21]

@amitchandak thanks for this formula,

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