Forum Discussion
rpinxt
Solution Sage
2 years agoFlag for the correct date bracket
I have this (filtered) visual : because of DateofManufacture it should show the 2nd line (4/20/2023 - 4/19/2028). So I am trying to come up with some sort of flag to filter on so only the ...
amitchandak
Super User
2 years agorpinxt , not very clear as both rows have the same date . In this case, you can use rownumber function with the date as order by along with other columns and partition by Shiptocountry , delivery, material , date of manfacturing
and then use visual level filter rownum =1
New DAX Function: Rownumber- https://www.youtube.com/watch?v=yS9-IQjUDwg&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=1
You can also check this report
Latest Date
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0