Forum Discussion
Solved
Filtering table by most recent data (with multiple different last entry dates)
I am having issues understanding which measures/filter I should be using to solve a problem I have with one of my Power B.I reports. My report is a status report for a series of projects within a...
I'd solve it by create a True/False DAX column like this:
displayInReport = VAR rowDate = [Project Update]
VAR projectName = [Project name]
RETURN
CALCULATE(
MAX('YourTable'[Project Updates]) = rowDate,
ALL('YourTable'),
'YourTable'[Project name] = projectName
)
Then filtering on this column for TRUE.
Thanks Ross this worked perfectly! i really appreciate the help!