Find the last day value;

Question

Please, I need some help.&nbsp;I intend to calculete the day by day price variation between the values of public traded&nbsp;stocks using DAX.After hour of reserch, I constructed the following expression, that&nbsp;gave me the current and the last price:&nbsp;&nbsp;SUMMARIZE (
&nbsp;&nbsp;&nbsp;&nbsp;ADDCOLUMNS (
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Inf_diario,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"PREVIOUS VL",
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VAR previousDate =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MAXX (
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER (
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Inf_diario,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Inf_diario[CNPJ_FUNDO] = EARLIER ( Inf_diario[CNPJ_FUNDO] )
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp; Inf_diario[DT_COMPTC] &lt; EARLIER ( Inf_diario[DT_COMPTC] )
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Inf_diario[DT_COMPTC]
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RETURN
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MAXX (
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER (
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Inf_diario,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Inf_diario[CNPJ_FUNDO] = EARLIER ( Inf_diario[CNPJ_FUNDO] )
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp; Inf_diario[DT_COMPTC] = previousDate
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Inf_diario[VL_QUOTA]
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;&nbsp;&nbsp;&nbsp;),
&nbsp;&nbsp;&nbsp;&nbsp;Inf_diario[ID],
&nbsp;&nbsp;&nbsp;&nbsp;Inf_diario[DT_COMPTC],
&nbsp;&nbsp;&nbsp;&nbsp;Inf_diario[VL_QUOTA],
&nbsp;&nbsp;&nbsp;&nbsp;[PREVIOUS VL]
)&nbsp;The&nbsp;results:&nbsp;Now, I need to find the diference between the PREVIOUS VL and VL QUOTA (current value), to finally calculate Standard deviation, %change etc.&nbsp;Tks in advance

mattbrice · Accepted Answer

It seems you are modeling off a single table and created a second calculated table. If so, i would do things a bit differently. &nbsp;I would use measures instead. &nbsp; First, put 'id' and 'DT_COMPTC' on rows of Matrix, then add the following measures:&nbsp;VL_Quota measure = SUM (Inf_diario[VL_Quota] )then:&nbsp;Previous VL Measure =
VAR _dates =
    FILTER (
        ALL ( Inf_diario[DT_COMPTC] ),
        Inf_diario[DT_COMPTC] &lt; MAX ( Inf_diario[DT_COMPTC] )
    )
VAR _previousDate =
    LASTNONBLANK ( _dates, [VL_Quota measure] )
RETURN
    CALCULATE ( [VL_Quota measure], Inf_diario[DT_CoMPTC] = _previousDate )then your % change is easy:&nbsp;% Change =
DIVIDE ( [Previous DL Measure] - [VL_Quota measure], [VL_Quota measure] )and so on.&nbsp;But if you want to continue to use your calculated table, you'll need to add more values via the ADDCOLUMNS you have.&nbsp;&nbsp;

Forum Discussion

Find the last day value;

2 Replies

Related content

Find Highest Value of a Column

Find MAX Value within a column

Finding the most recent value

find max value based on another filtered column

DAX Calculation - Find value based on day (relative)