topic Re: Question regarding data summation in Developer

Question regarding data summation

ysapiyev — Sat, 20 Jan 2018 10:53:09 GMT

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?

Re: Question regarding data summation

Greg_Deckler — Sat, 20 Jan 2018 17:08:31 GMT

Define "latest values"

Re: Question regarding data summation

ysapiyev — Mon, 22 Jan 2018 04:41:22 GMT

@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?

Re: Question regarding data summation

Greg_Deckler — Mon, 22 Jan 2018 13:59:26 GMT

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

Re: Question regarding data summation

ysapiyev — Mon, 22 Jan 2018 14:06:45 GMT

@Greg_Deckler,

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

Re: Question regarding data summation

v-chuncz-msft — Tue, 23 Jan 2018 09:50:42 GMT

@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.