Forum Discussion
Custom Columns or Measures in a DirectQuery report
All, I have a set of reports that i configured to read data from a given application database. I love using the DirectQuery mode for these reports, as I query from a DR instance which is fresh ...
You could consider this DAX function and use it in a measure.
Syntax:
DATEDIFF(<start_date>, <end_date>, <interval>)
It returns the count of interval boundaries crossed between two dates.
Best Regards
Maggie