Dont show column value in matrix until you drill down

[Anonymous]

Hello,

I want to represent invoice date when in matrix rows are expanded and you see invoice number and invoice date. Issue is that I need to show either First or Last value when it is not expanded and it can be confusing to end user. How do I show that value as blank until it gets expanded?

Current situation:

After drill down

What it should look like is (edited with paint):

 

[Bifinity_75 · Accepted solution]

Hi @Anonymous , try this:

Earliest date measure = SWITCH(TRUE(),
ISINSCOPE("Your column with data AHA-..."),
max(Table[Earliest date)],""
)

You will have to create a new identical measure for the other date

Best regards

[Anonymous]

Thank you very much. This is exactly what I needed!