Forum Discussion

Sentinel997's avatar
Sentinel997
Frequent Visitor
4 years ago
Solved

Show only record with current date

    In a report, I get several data records under storage date (Einlagerungsdatum). Some of these records have the same chassis number. Does anyone have an idea that only the most recent (date) r...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Sentinel997 ,

     

    Method1: Change the summarized type as "Latest":

    Method2:  Create a measure: 

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

    Method3: If you just want to display the latest row, please follow jbwtp 's method to create a flag measure for filter:

    Filter Flag = 
var _latest=CALCULATE(MAX('Table'[Date]),FILTER(ALL('Table'),[FZFZTP]=MAX('Table'[FZFZTP])))
return IF(MAX('Table'[Date])=_latest,1,0)

    And then apply it to visual-level filter pane, set as "is 1":

     

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

Sentinel997's avatar
Sentinel997
Frequent Visitor
4 years ago

thanks for the hint.
However, it still doesn't work.

jbwtp's avatar
jbwtp
Memorable Member
4 years ago

Hi Sentinel997,

 

This is because, I've ignored that you have more columns and they are also varied across same vehicle type.

Try this one and see if this works for you:

 

Measure = if(CALCULATE(MAX(RRDVREP[Einlagerungsdatum]), ALLEXCEPT(RRDVREP,RRDVREP[FZFZTP])) = MAX(RRDVREP[Einlagerungsdatum]), 1, 0)

 

 

Cheers,

John