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"

@ 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!: The Definitive Guide to Power Query (M)

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.

@ 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!: The Definitive Guide to Power Query (M)

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.

Question regarding data summation

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024