March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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):
Solved! Go to 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
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
Thank you very much. This is exactly what I needed!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
164 | |
116 | |
63 | |
57 | |
50 |