How to display values that didn't appear the week before

[Stubbz66]

Hi Power BI Community

I've been asked by a customer to provide a table that shows on any given selected week the values that DIDN'T appear the week before.

So from the table below they would want a seperate table that shows driver 220,303,311,325 did NOT appear in week 3. Is this possible? and if so how do I go about it! Any help will be greatly appreciated.

[rubinboer · Accepted solution]

hi @Stubbz66 

consider this:

• assumption your columns will be 3/4
• Check for unique drivers by using DISTINCTCOUNT
• Check where there is one in 4 (!ISBLANK()) and not in 3 (ISBLANK)

Measure

Not present previous Week = CALCULATE(DISTINCTCOUNT('Drivers'[Drivers]), NOT(ISBLANK(Drivers[4])), ISBLANK(Drivers[3]))

Result

Filter the driver on the measure and show that only

[Stubbz66]

Many thanks for the quick response Rubinboer. I'll put this into action later today!