Forum Discussion

Anonymous

Not applicable

8 years ago

Measure for DateDiff

Can someone help me out with the datediff measure for a list of different Stages and different Quotes Have a look at the screenshot below

Super User

8 years ago

Hi Anonymous,

DateDiff should be used as a Column, not a measure

Difference = DATEDIFF(Table1[Last Modified], TODAY(), DAY)

If this solves, accept the solution and give a kudos!!

Anonymous

Not applicable

8 years ago

Your measure does not give an accurate result. See the screenshot below.

I need the first row in the (Diffrence Collumn) of every new Q No to be empty; start of new start stage change, just like my ealier posting !