Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Many thanks, this helped me to fix it.

  • saud968's avatar
    saud968
    1 year ago

    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!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

I create a table as you mentioned.

It looks like the KEEPFILTERS function is causing an issue because it needs to be used within CALCULATE or CALCULATETABLE.

So I think you can change your codes.

EVALUATE
VAR __DS0FilterTable4 =
    CALCULATETABLE (
        FILTER ( ALL ( 'SDT Clarity Tasks'[ETD] ), 'SDT Clarity Tasks'[ETD] = TODAY () )
    )
RETURN
    __DS0FilterTable4

Then you will get what you want.

 

 

Best Regards

Yilong Zhou

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    That's great, thank you