Re: Formula em Direct Query

Anonymous · ‎02-17-2022

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

PijushRoy · ‎02-17-2022

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

Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!

PijushRoy · ‎02-17-2022

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

Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!

Anonymous · ‎02-17-2022

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 · ‎02-17-2022

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?

Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!