Calculation with date filter and Ids, Power BI

Question

Good morning,

I need to create a measure that makes the following calculation:

(Line value)/(Initial value)

However the calculation should be done respecting the ID (not divided by values of other Ids, and the base should be dynamic with the date filter).

Below the table format I have (all data are columns in the database).

As an example, the first values of ID 9 should be: (3,21/3,21) = 1; (3,24/3,21) = 1,009.

I created several measures but did not succeed in the execution of the task.

Thanks in advance.

Answer 1

Try to use the DIVIDE(Tabela['coluna'];Tabela['coluna2']), so it makes the division respecting the Ids. Then change the amount of decimals.

Answer 2

I believe that’s it:

You need to have a calendar dimension table (to use the itenerante function)

1. Last Selected Value = SELECTEDVALUE(Plan1[VALOR CONVERTIDO])

2. Last Selected Value - 1 =

CALCULATE(
    [Último Valor Selecionado];
    DATEADD(
        dCalendario[Data];-1;MONTH
    )
)

3. Measure = [Último Valor Selecionado]/[Último Valor Selecionado - 1]

I hope you answer.

Answer 3

First Selected Value =

> CALCULATE(
>     [Último Valor Selecionado];
>     FIRSTDATE(
>         ALLSELECTED(
>             Planilha1[DATA]
>         )
>     ) 
)

Desired Measure =

[Último Valor Selecionado]/[Primeiro Valor Selecionado]