DAX DirectQuery No. of days from previous order date to Today date

[Vinit]

Hello all experts,

I want a DAX fromula No. of days between order date and Todays date in DirectQuery mode

In above screenshot, 12/08/22 is my Order Date and 31/10/22 is Todays date so, No. of days between date is 80

So, I want Dax Formula which is Applied in DirectQuery mode, 

I used this DAX,

Day Count = DATEDIFF(Query1[orderdate],Today(),DAY) 

But it is not applicable.

Meaasge if anything require.

[johnt75 · Accepted solution]

Try

Day Count = DATEDIFF(SELECTEDVALUE(Query1[orderdate]),Today(),DAY)

[Vinit]

Yes it worked. Thanks