Forum Discussion

ank47's avatar
ank47
New Member
4 years ago
Solved

Using Cards to show latest data without aggregation

I am using a dashboard to track latest data from "Sales" column. This "Sales" column is a measure of Whole number data type. Whenever i am trying to use it as a card it shows aggregation. I just want...
Data Protection
  • vojtechsima's avatar
    vojtechsima
    4 years ago

    ank47 
    Incorporate this into your measure:

    TakeTheLatestAmount = 

var LatestDate = MAX(MEasure_First[Date])
var LatestValue = MAXX(FILTER(MEasure_First, MEasure_First[Date] = LatestDate), MEasure_First[Sales (Measure : Whole number)])

return LatestValue

     

vojtechsima's avatar
vojtechsima
Super User
4 years ago

Hi, ank47 
I am a bit confused with your words usage.

So you mean that you created a Calculated Column that returns a numeric value and you want to show the latest?
If that is true, you can just filter the latest date (if you have Date column in your table) in Filter Pane of that visualization or you can write a measure that takes the latest date and take the value from that New Column (you created) and then you just display the Measure.