Forum Discussion
lennox25
Post Patron
Post PatronHow to highlight differences between two tables -showing data thats on one table and not on another
I have two tables not related. I need to highlight any missing dates between both tables. This example only shows dates missing on the second table but for other stores dates could be missing from th...
Try the following code:
1- In the first table put the following code:Column=VAR data = 'Your_Current_Table'[Date]VAR result =LOOKUPVALUE('Your_Second_Table'[Date],'Your_Second_Table'[Date],'Your_Current_Table'[Date]) = dataRETURNresult2- Create a measure with the following code:Measure= SUM('Your_Current_Table'[Column])3- In your matrix, format conditionaly your values as shown bellow. Make sure that your based field is the measure created before
Bibiano_Geraldo
Super User
Super UserTry the following code:
1- In the first table put the following code:
Column=
VAR data = 'Your_Current_Table'[Date]
VAR result =
LOOKUPVALUE(
'Your_Second_Table'[Date],
'Your_Second_Table'[Date],
'Your_Current_Table'[Date]
) = data
RETURN
result
2- Create a measure with the following code:
Measure= SUM('Your_Current_Table'[Column])
3- In your matrix, format conditionaly your values as shown bellow. Make sure that your based field is the measure created before
lennox25Post Patron
Post PatronThank you - your brilliant!