cancel
Showing results forย
Did you mean:ย
Helper IV

## Chart by last value of month

Hi, I want to know how I can get the last data of each month and show it in a bar graph. For example in March you must show me 1, on April -13, on May -2.

 8/3/2017 -1 9/3/2017 -1 10/3/2017 0 11/3/2017 0 12/3/2017 1 13/3/2017 10 14/3/2017 2 15/3/2017 0 16/3/2017 0 17/3/2017 0 18/3/2017 0 19/3/2017 0 20/3/2017 0 21/3/2017 0 22/3/2017 0 23/3/2017 0 24/3/2017 0 25/3/2017 0 26/3/2017 0 27/3/2017 1 28/3/2017 0 29/3/2017 0 30/3/2017 -1 31/3/2017 1 1/4/2017 0 2/4/2017 0 3/4/2017 0 4/4/2017 5 5/4/2017 8 6/4/2017 -2 7/4/2017 -11 8/4/2017 -6 9/4/2017 -11 10/4/2017 -29 11/4/2017 -29 12/4/2017 -14 13/4/2017 -19 14/4/2017 -2 15/4/2017 -7 16/4/2017 -9 17/4/2017 -9 18/4/2017 -27 19/4/2017 -20 20/4/2017 -20 21/4/2017 -28 22/4/2017 -17 23/4/2017 -6 24/4/2017 2 25/4/2017 0 26/4/2017 -17 27/4/2017 -23 28/4/2017 -21 29/4/2017 -17 30/4/2017 -13 1/5/2017 -11 2/5/2017 5 3/5/2017 -9 4/5/2017 -26 5/5/2017 -12 6/5/2017 -9 7/5/2017 -22 8/5/2017 -18 9/5/2017 -7 10/5/2017 -14 11/5/2017 -38 12/5/2017 -20 13/5/2017 -30 14/5/2017 -22 15/5/2017 -14 16/5/2017 -39 17/5/2017 -30 18/5/2017 -22 19/5/2017 1 20/5/2017 -7 21/5/2017 -20 22/5/2017 -21 23/5/2017 -8 24/5/2017 -20 25/5/2017 -16 26/5/2017 -19 27/5/2017 -14 28/5/2017 -8 29/5/2017 -18 30/5/2017 -18 31/5/2017 -2

3 ACCEPTED SOLUTIONS
Community Champion

@jracer007

Hi, you can use this measure:

```LastValue =
CALCULATE ( MAX ( Table1[Value] ), LASTDATE ( Table1[Date] ) )```

Regards

Victor

Lima - Peru

Lima - Peru
Community Champion

@jracer007

Fรญjate en el panel de formato de tu grรกfico el campo fecha si es que estรก en jerarquia.

Look in the format panel of the chart and review if the Date Column is in Hierarchy Option.

Lima - Peru
Community Champion

@jracer007

Replace this measure:

```Este Aรฑo2 =
CALCULATE (
MAX ( 'Mi Tigo App'[Active Users] ),
FILTER (
'Mi Tigo App',
'Mi Tigo App'[Active Users] <> BLANK ()
&& 'Mi Tigo App'[Date] = LASTDATE ( 'Mi Tigo App'[Date] )
)
)```

Lima - Peru
13 REPLIES 13
Community Champion

@jracer007

Hi, you can use this measure:

```LastValue =
CALCULATE ( MAX ( Table1[Value] ), LASTDATE ( Table1[Date] ) )```

Regards

Victor

Lima - Peru

Lima - Peru
Helper IV

Hablas espaรฑol?

Community Champion

@jracer007

Si

Lima - Peru
Helper IV

Veras soy nuevo en esto de Power BI necesito ayuda creando un filtro para los mismos datos que te mostre. El filtro debe ser por rango de fechas: "Aรฑo Anterior", "Este Aรฑo", "Mes Pasado", "Ultimos 30 dias", "Este Mes". Por favor si eres tan amable. Gracias

Community Champion

@jracer007

You can try using relative option in slicer.

Puedes tratar usando la opciรณn relative en el slicer.

Lima - Peru
Helper IV

Una ultima cosita, como hago para que me muestre la suma de cada mes, en vez de mostrarme dia por dia.

Community Champion

@jracer007

Fรญjate en el panel de formato de tu grรกfico el campo fecha si es que estรก en jerarquia.

Look in the format panel of the chart and review if the Date Column is in Hierarchy Option.

Lima - Peru
Helper IV

Pero no me aparece noviembre, solo hasta octubre

Community Champion

@jracer007

Si puedes compartir tu archivo sin las columnas confidenciales o anonimizadas (Vรญa dropbox, drive or onedrive) para revisarlo y dar una soluciรณn.

If you can share your file (PBIX) without confidencial data to review it and bring a solution.

Regards

Victor

Lima - Peru
Helper IV
Community Champion

@jracer007

Replace this measure:

```Este Aรฑo2 =
CALCULATE (
MAX ( 'Mi Tigo App'[Active Users] ),
FILTER (
'Mi Tigo App',
'Mi Tigo App'[Active Users] <> BLANK ()
&& 'Mi Tigo App'[Date] = LASTDATE ( 'Mi Tigo App'[Date] )
)
)```

Lima - Peru
Helper IV

Una ultima cosita tengo dos lineas llmadas cumplimiento y penetracion, son pรณrcentajes pero se muestran como un decimal.

Saludos

Helper IV

Gracias amigo eres genial

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!