DAX expression to calculate elapsed days from current date

[CLANG10]

Hi, How do i write a DAX expression to calculate the elasped days from current date in table below... Thanks in advance for the advise.

[v-henryk-mstf · Accepted solution]

Hi @CLANG10 ,

In my tests, everything works fine whether the column is created as a measure or a calculated column, so you can check if there is a problem.

Days = 
var cur = 'Table'[Date]
return DATEDIFF(cur,TODAY(),DAY)

M_days = 
var cur = MAX('Table'[Date])
return DATEDIFF(cur,TODAY(),DAY)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Thennarasu_R]

Try this in measure
   Measure = var A=min(Submission date)
                     var B=max (Current date)
         return
             Var B- Var A
Let me known I will Work or not.

[CLANG10]

Thanks...but still can't work...

[amitchandak]

@CLANG10 ,

You can create a new column

Diff= datediff([Submission Date], Today(), Day)

[CLANG10]

Hi Amit, thank you for the response, could u further advise how to auto apply this to all the rows in the table...i got the syntax error below...

[Arul]

@CLANG10 ,

Did you created the calculated column? And, Can I ask the reason for using ALLSELECTED in the DAX expression?

Thanks,