Forum Discussion
datadmin-austin
Helper I
Helper ICompare 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 ...
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
Super User
Super User
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.
DataInsightsSuper User
Super UserYou'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).