Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 the first table. In this example I would like the missing dates from Table 2 highlighted in table 1. So 10/04/23, 16/04/23 and 23/04/23 would be highlighted.
Solved! Go to Solution.
Try the following code:
1- In the first table put the following code:
@lennox25 you can write a measure like this
Measure=
VAR _left =
{ MAX ( t1[Date] ) }
VAR _RIGHT =
GENERATE ( _left, VAR ky = [Value] RETURN FILTER ( t2, t2[Date] = ky ) )
RETURN
IF (
COUNTROWS ( _RIGHT ) == BLANK (),
"missing in 2nd table",
"not missing in 2nd table"
)
Try the following code:
1- In the first table put the following code:
Thank you - your brilliant!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
71 | |
38 | |
29 | |
26 |
User | Count |
---|---|
97 | |
96 | |
58 | |
44 | |
41 |