Forum Discussion

datadmin-austin's avatar
datadmin-austin
Icon for Helper I rankHelper 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...
General Comment
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    datadmin-austin,

     

    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 () )
)

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
4 years ago

datadmin-austin,

 

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's avatar
datadmin-austin
Icon for Helper I rankHelper I
4 years ago

DataInsights Thank you very much! That all worked very well. I have one last question, what is the best way to handle changes in the "Date"?

 

For example, if I only want it to show audits with dates from Quarter 1 or if I want it to show inspecitons from the last 180 days. I added filters to each date which works, but some data is still missing when using filters. Thank you!