Create a new table according to criteria

[Magliasoft]

Hello friends, I am a beginner in power bi and would like help depending on the criteria below

I have the following table:

Based on the last date I need to bring the cost of the cod 104.007.400.004

Result is 06/12/16 - Cost US$ 0.13

Creating a table with unique records

thank you

[Ashish_Mathur]

Hi @Magliasoft,

You poasted the same question here yesterday.  Please stick to one thread.

[Magliasoft]

Hi

With this function found here in the forum I solved part of the problem, I need to bring a table field and do the division
Example: cost / table = Percentage
013 / 0.95 = 13.68%

Thank You

[Magliasoft]

.Tabela = ADDCOLUMNS(
    SUMMARIZE (
        MovimentoEntrada;
        MovimentoEntrada[COD_ITEM];
        "Data Operacao"; MAX ( MovimentoEntrada[DATA_OPERACAO] )
    );
    "CIF"; CALCULATE (
        SELECTEDVALUE ( MovimentoEntrada[CIF] );
        FILTER (
            MovimentoEntrada;
            MovimentoEntrada[DATA_OPERACAO] = [Data_Operacao]
                && MovimentoEntrada[COD_ITEM] = EARLIER ( MovimentoEntrada[COD_ITEM] )
        )
    )
)

[Greg_Deckler]

Not certain I completely understand what you are going for here. You can create a measure like:

FinalCost = CALCULATE(MAX(table[COST]),FILTER(table,Date=MAX(Date)))

You can place this measure into a table visualization along with Cod.

[Magliasoft]

Hello friends, I am a beginner in power bi and would like help depending on the criteria below

I have the following table:

Based on the last date I need to bring the cost of the cod 104.007.400.004

Result is 06/12/16 - Cost US$ 0.13

Creating a table with unique records

thank you

[Ashish_Mathur]

Hi,

So for each Cod, you'd like to determine the cost as on the last date.  Am i correct?  If yes, then please share the download link of your file.