Help with DAX Related with filter functions

[riadorra]

Hi

I have 2 tables fEstoque and dCadastroProdutos and the are related many to one.

In fEstoque, i have a column named ULTIMA ATUALIZACAO and another named ULTIMA COMPRA 

What DAX formula should i use in order to bring to dCadastroProdutos the ULTIMA COMPRA values, but only the ones that have the text SIM at ULTIMA ATUALIZACAO column

thank you

[Anonymous · Accepted solution]

Hello,

@riadorra, how does your table are structured? Can you show some data? Are the "ULTIMA ATUALIZACAO" "SIM" values unique for an given Product?

For example:

These are the table data:

Like you can notice, for each product there is only one row containing the value "SIM". Am I right? 

These are my soltions for both calculated column and measure:

CALCULATE(FIRSTNONBLANK(fEstoque[ULTIMA COMPRA]; 0); fEstoque[ULTIMA ATUALIZACAO] = "SIM")

And this is a table visual:

Since that for Product C there is not a "SIM" valeu on fEstoque, the return value is blank.

But, if your data has more than one "SIM" value for each produtct I will need some more explanation.

Hope it helps!

[riadorra]

Hi caaarlos,

yes, there's only 1 "SIM". it worked well.

I've tried another function and it worked too 

LOOKUPVALUE(fEstoque[data ultima compra];fEstoque[codigoproduto];dCadastroProdutos[Codnumero];fEstoque[ultima atualizacao];"sim")

Thank you very much

Riad