Forum Discussion

datadmin-austin's avatar
datadmin-austin
Helper I
4 years ago
Solved

Compare 2 Columns

Hello All,   We run safety audits daily and I have 2 different SharePoint Lists. One is just building details and the other are audit score details, but they both have building names on them. I am ...
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    datadmin-austin,

     

    Try these measures:

     

    Audit Score Percentage = MAX ( Table2[AuditScorePercentage] )
    Audit Date = MAX ( Table2[Date] )

     

    In the visual, use Table1[BuildingNameColumn] and enable "Show items with no data". Add the measures above to the visual.

     

     

     

DataInsights's avatar
DataInsights
Super User
4 years ago

datadmin-austin,

 

Try these measures:

 

Audit Score Percentage = MAX ( Table2[AuditScorePercentage] )
Audit Date = MAX ( Table2[Date] )

 

In the visual, use Table1[BuildingNameColumn] and enable "Show items with no data". Add the measures above to the visual.

 

 

 

  • DataInsights's avatar
    DataInsights
    Super User
    4 years ago

    You'll need a relationship between the tables. Crossfilter direction is "Both" since it's a 1:1 relationship. This can be changed to 1:* if desired ("Single" crossfilter direction).

     

     

  • datadmin-austin's avatar
    datadmin-austin
    Helper I
    4 years ago

    DataInsights That worked! I kept missing the "Show items with no data" option. Thank you for the details and visuals!