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

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Do you have a Date column?  Share the download link of your PBI file for more help.