Question regarding data summation

[ysapiyev]

Hi everyone,

I noticed, that when I have data with date, and I use slicer by date, my data displays summation of my values over selected period. Is there any ways to display latest values from selected period?

[Greg_Deckler]

Define "latest values"

[ysapiyev]

@Greg_Deckler,

I have range of values for a period of time, and when I use data slicer, to select range of dates, I get summation of data. How can I get only data for latest date?

[Greg_Deckler]

You would need to use a MAX or MIN in your measure calculation.

[ysapiyev]

@Greg_Deckler,

Is it possible to use them in custom visual? I mean through coding.

[v-chuncz-msft]

@ysapiyev,

Even if this can be done, it might not be appropriate. For the DAX solution, visit http://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer.