Direct Query calculations

Hi,

I am trying to calculate the number of days from a date field to today, but I have to work in Direct Query mode and it is giving the error that the column will not be created.

Is there any way around this?