Forum Discussion
DAX date today query
Hello everyone, Within a step in a flow to Run a query against I dataset, I wish to just retrieve items from a column called ETD where the date is "today" but I am getting an error when I try to ...
Many thanks, this helped me to fix it.
Please accept the correct answer as a Solution.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
Hi Anonymous ,
Try adding the EVALUATE and RETURN keywords as shown below. Also, your syntax for the filter query seems incorrect. Please try this code :
EVALUATE
VAR __DS0FilterTable4 =
KEEPFILTERS (
FILTER (
ALL ('SDT Clarity Tasks'[ETD] ),
'SDT Clarity Tasks'[ETD] = Today ()
)
)
RETURN
__DS0FilterTable4