Forum Discussion
Solved
Show only data from the latest date
Dear all, I have a very basic question. I constantly struggle with showing only the data with the newest date. What is the easiest way to get a visual only to show data from the most recent date. ...
Hi ChristianTD,
Seems date type values don't have a "TOP" filter type. I would suggest you try the measure below and add it to the "Visual Level filter". Don't need to add it to any visual. Then filter the filter as "1". Please give it a try.
Measure = VAR LatestDate = CALCULATE ( MAX ( 'Table1'[Date] ), ALL ( 'table1' ) ) RETURN IF ( MIN ( 'Table1'[Date] ) = LatestDate, 1, 0 )Best Regards,
Dale
mcash
Helper I
Helper II know this is an old thread, but what if I want to pull the most recent date for a column while also preserving a filtered column. Example: I have raw materials that go to different warehouses and the unit price can be different between warehouses. The file I have includes unit price updates. I used the formula from this thread and it works, but it only pulls the price for the most recent date regardless of warehouse.
| Warehouse | Raw Material | Unit Price | Price Update |
| W1 | Raw A | $ 4.00 | 11/1/2022 |
| W1 | Raw A | $ 3.00 | 10/1/2022 |
| W1 | Raw A | $ 2.00 | 9/1/2022 |
| W1 | Raw A | $ 1.00 | 8/1/2022 |
| W2 | Raw A | $ 4.25 | 11/1/2022 |
| W2 | Raw A | $ 3.25 | 10/1/2022 |
| W2 | Raw A | $ 2.25 | 9/1/2022 |
| W2 | Raw A | $ 1.25 | 8/1/2022 |
| W1 | Raw B | $ 3.00 | 10/5/2022 |
| W1 | Raw B | $ 2.75 | 9/5/2022 |
| W1 | Raw B | $ 2.50 | 8/5/2022 |
| W1 | Raw B | $ 2.25 | 7/5/2022 |
| W2 | Raw B | $ 2.00 | 11/1/2022 |
| W2 | Raw B | $ 1.75 | 10/1/2022 |
| W2 | Raw B | $ 1.50 | 9/1/2022 |
| W2 | Raw B | $ 1.25 | 8/1/2022 |
| W1 | Raw C | $ 2.00 | 11/1/2022 |
| W1 | Raw C | $ 1.75 | 10/1/2022 |
| W2 | Raw C | $ 2.50 | 9/1/2022 |
| W2 | Raw C | $ 2.25 | 8/1/2022 |
Ashish_Mathur
Super User
Super UserHi,
Show the expected result very clearly.