Formula em Direct Query

[Anonymous]

Can I use in a direct query a formula as a date filter (date is returned by a dax formula?

[PijushRoy]

Is it possible to share sample data and your expected result.

[PijushRoy]

What is the usae of date filter? 
Date filter DAX for measure?

[Anonymous]

I tried to use the formula below:

AntStock502W_Branch1 =

CALCULATE(

    SUMX('Stock_Diary_502_Branch_1',[ESTOQUE_DIARIO_502_1] ),

    FILTER( 'Estoque_Diario_502_Filial_1', [DATA] = [DataEstoqAnt502_Filial1])) where DataEstoqAnt402_Filial1 is a dax formula that returns the last date that had movement. , but the formula is returning the wrong value.

[bcdobbs]

In principal what you're trying to do is fine. I suspect the reason you're getting wrong values is that your measure

is being evaluated in the context of each row in your filter table (measures force a

context transition.) Depending on what result you're trying to achieve you want to read the value into a variable earlier on to fix it. As @PijushRoy suggests can you share a sanitised pbix file?