Forum Discussion

Helper I

4 years ago

Solved

Compare / Combine Data

Hello All, I have 2 tables - one has a list of locations, the 2nd has a list of locations, date of inspections, and scores of those inspections (Two different types of inspections) for each locat...

4 years ago

I revised the two measures below:

Audit Date 1 = 
IF ( MAX ( Table2[AuditScorePercentage1] ) <> BLANK (), MAX ( Table2[Date1] ) )

Audit Date 2 = 
IF (
    MAX ( Table2[AuditScorePercentage2] ) <> BLANK (),
    CALCULATE ( MAX ( Table2[Date1] ), Table2[AuditScorePercentage2] <> BLANK () )
)

datadmin-austin

Helper I

4 years ago

DataInsights Thank you! Do you have a sample date table?

I believe I got this to work, but I have not finished testing, see my table here and feel free to judge how it looks or if there are more fields that should be added to further filter dates.