Measure to calculate the number of days between due event date and today date

[Anonymous]

Hi,

I have a task event date in the past. This task was not reported as done and it's on hold.

I can create a Column with Datediff (Due Date, Date(), but would like to create a Measure instead.

My Event table have muilty tasks open for muilty units.

Thank you!!

[Anonymous · Accepted solution]

Hi Guys,

Just found the solution:

[ # Days] = SUMX(JOBSTABLE, DATEDIFF(JOBSTABLE[Date], [ZToday],DAY))

ZToday is a measure= TODAY()

Hope will help someone else.

Jose Milhazes

[Phil_Seamark]

Hi @Anonymous

Why do you want to create it as a measure instead of a column

[Anonymous]

Hi @Phil_Seamark,

Main reason is my dataset is reaching the PBI limits, and the file size is also growing fast.

Let me continue to investigate.

Regards

Jose Milhazes