Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculating a Measure over Time

Hi, I am trying to create a series of calculation where I have a report date (say 10/1) and am trying to show the days since creation and days since last verified.   My problem is that I need this...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Anonymous 

 

If I understand it correctly, you can try these measures:

 

Days Since Created = 
VAR monthStart = MIN('Date'[Date])
RETURN
SUMX('Table',DATEDIFF('Table'[Created],monthStart,DAY))
Days Since Verified = 
VAR monthStart = MIN('Date'[Date])
RETURN
SUMX('Table',DATEDIFF('Table'[Last Verified],monthStart,DAY))

 

I have a Date table in the demo. You can download the attachment at bottom to see details. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.