Forum Discussion
AaronM
7 years agoNew Member
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...
- Anonymous7 years ago
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.
- 7 years ago
Hi AaronM
As tested, Ross73312's method is helpful, you need to create a caluclated column with his formula,
then add this column in a slicer, add other columns in a Table visual,
finally when you select "true" from that slicer, the table would show the lastest data for each project.
Or you could create a measure, then add this measure in the Visual Level filter, select "show items when value is 1".
Measure =
IF (
MAX ( [Project Update] )
= CALCULATE (
MAX ( [Project Update] ),
ALLEXCEPT ( 'DATA SET EXAMPLE', 'DATA SET EXAMPLE'[Project name ] )
),
1,
0
)Best Regards
Maggie
Anonymous
7 years agoNot applicable
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.
- AaronM7 years agoNew Member
Thanks Ross this worked perfectly! i really appreciate the help!