Forum Discussion

New Member

3 years ago

Solved

remove historical data from table

Hi, I am facing issue in creating Table 2 from Table 1. Table 1 has historical records for the host. I want to keep the latest row data for each host in Table 2. please refer Table 1 Hos...

Need Help

amitchandak
3 years ago
salil , a new table

Filter(AddColumns(Table1, "Max Date", maxx(filter(Table, [Host] = earlier([Host])), [Date])), [Date] = [Max Date])

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee884e

v-yanjiang-msft

Community Support

3 years ago

Hi salil ,

If you want a seperate table, amitchandak 's solution works fine. If you want a visual to display the expected result, here's my solution. Create a measure:

Measure =
IF (
    MAX ( 'Table'[Date] )
        = MAXX (
            FILTER ( ALL ( 'Table' ), 'Table'[Host] = MAX ( 'Table'[Host] ) ),
            'Table'[Date]
        ),
    1,
    0
)

Put the measure in the visual filter and set to 1.