Forum Discussion
Issues with filtering by date
Hi all, I am after some help please. I have a table visual which is pulling data from a couple of different data tables. I have a list of "application names" and I am trying to filter them by...
Hello AndrewMarkham86,
Instead of directly pulling in the "Last Updated" column, can you please try creating a DAX measure that dynamically finds the latest update per application.
Last Updated Date =
CALCULATE(
MAX('Update Table'[Update Date]),
ALLEXCEPT('Update Table', 'Update Table'[Application Name])
)
Would I be able to do this, with the fact the it is pulling the data from two different data tables. It is pulling the "application name" from one table and "updated date" from another?
Thank you.
