Forum Discussion

Frequent Visitor

5 years ago

Solved

Checking for max value in summarized table DAX help

Hi everyone. I have data that looks like this: TestCaseID Configuration RunDate 1 1 08-04-2021 11:10:10 1 1 08-04-2021 12:10:10 1 2 08-04-2021 13:10:10 2 1 08-04-2021 08:...

Need Help

Jihwan_Kim
5 years ago
Hi, KasperBI

Please correct me if I wrongly understood your question.

Please check the below Calculated Column and the link down below, which is the sample pbix file.

Latest Test Column =
VAR lastnonblankcheck =
CALCULATE (
LASTNONBLANK ( 'Test Results'[RunDate], MAX ( 'Test Results'[Configuration] ) ),
ALLEXCEPT (
'Test Results',
'Test Results'[TestCaseID],
'Test Results'[Configuration]
)
)
RETURN
IF ( 'Test Results'[RunDate] = lastnonblankcheck, "Keep", "Remove" )

https://www.dropbox.com/s/xxpqyuj3xk6l2or/KasperBI.pbix?dl=0

Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Jihwan_Kim

Super User

5 years ago

Hi, KasperBI

Please correct me if I wrongly understood your question.

Please check the below Calculated Column and the link down below, which is the sample pbix file.

Latest Test Column =
VAR lastnonblankcheck =
CALCULATE (
LASTNONBLANK ( 'Test Results'[RunDate], MAX ( 'Test Results'[Configuration] ) ),
ALLEXCEPT (
'Test Results',
'Test Results'[TestCaseID],
'Test Results'[Configuration]
)
)
RETURN
IF ( 'Test Results'[RunDate] = lastnonblankcheck, "Keep", "Remove" )