79832074

Date: 2025-11-27 20:57:06
Score: 1.5
Natty:
Report link

If the measure is just used for this check, one table is enough.

Check = 
VAR __wd =
    WINDOW( -12, REL, 0, REL, ALL( DATA[MonthYr] ) )
RETURN
    IF(
        CALCULATE( ISEMPTY( DATA ), __wd, DATA[Flag] = 1 ),
        "no missing data",
        "missing data"
    )

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: ThxAlot