Re: Question regarding data summation

ysapiyev · ‎01-20-2018

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 · ‎01-20-2018

Define "latest values"

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

ysapiyev · ‎01-21-2018

@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 · ‎01-22-2018

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

ysapiyev · ‎01-22-2018

@Greg_Deckler,

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

v-chuncz-msft · ‎01-23-2018

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.