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 to show the latest information without any aggregation just like any text column.

 

I have tried creating a new measure which duplicates the "Sales" column using "FIXED" to convert it into text. But, using it in a card dosent allow me to choose "First" or "Last" values.

 

DateSales (Measure : Whole number)Sales (Text)
2/1/202200
2/2/2022100100
2/3/202200
2/4/2022100100
2/5/2022100100

 

 

 

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

     

4 Replies

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

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

  • vojtechsima's avatar
    vojtechsima
    Super User
    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

     

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, ank47 

     

    Maybe you can just use measure to come up with the latest values.

    Measure:

    Latest = 
CALCULATE([Sales(Text)],FILTER(ALL('Table'),[Date]=MAX('Table'[Date])))

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.