Forum Discussion

RichardT_78's avatar
RichardT_78
Helper I
6 years ago
Solved

Returning the latest data row

Hi All    I cant find how to display duplicate data - have have seen some simple right click remove duplicate copies but i dont have these option available to me as im using a live dataset connecti...
Need Help
Tips and Tricks
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi RichardT_78 

     

    this Measure should work with the updated scenario.

    Measure 10 = 
VAR __maxDate = 
    CALCULATE(
        MAX( Table[Date] ),
        ALLEXCEPT( Table, Table[Robot] )
    )
RETURN 
CALCULATE(
    COUNTROWS( Table ),
    TREATAS( { __maxDate }, Table[Date] )
)

    Later you can use it in a filter pane as filters on this visual, like below.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi RichardT_78 

 

this Measure should work with the updated scenario.

Measure 10 = 
VAR __maxDate = 
    CALCULATE(
        MAX( Table[Date] ),
        ALLEXCEPT( Table, Table[Robot] )
    )
RETURN 
CALCULATE(
    COUNTROWS( Table ),
    TREATAS( { __maxDate }, Table[Date] )
)

Later you can use it in a filter pane as filters on this visual, like below.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

RichardT_78's avatar
RichardT_78
Helper I
6 years ago

Worked Perfectly Mariusz

 

Thank you for your help