Gaps in time data

Hi Anonymous 

Thanks for reaching out to us.

>> Is it possible not to make a new table and just a measure

yes, you can try this way

(1) use matrix, then create a measure

Measure = SWITCH(TRUE(),
ISBLANK(MIN('Data table'[dist_since_last_update])),"No data",
MIN('Data table'[dist_since_last_update])=0,"Passive",
MIN('Data table'[dist_since_last_update])>0,"Active"
)

(2) create the measure below, put it into conditional formatting

conditional formatting = SWITCH(TRUE(),
ISBLANK(MIN('Data table'[dist_since_last_update])),"light grey",
MIN('Data table'[dist_since_last_update])>0,"green",
MIN('Data table'[dist_since_last_update])=0,"pink")

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.