Forum Discussion
EMGI
8 years agoFrequent Visitor
Distinct Value between date range
Hey everybody...i need your help! I have a calculated table you can see below: In the first column you can see one product (but got many different ones; this ist just an example), the "ord...
EMGI
8 years agoFrequent Visitor
Hello again,
has nobody an idea or an easy step how to move forward on this issue?
Any help would be appreciated.
Thanks again...
v-jiascu-msft
8 years agoMicrosoft Employee
Hi EMGI,
Can you share your file? (Please be aware of your privacy) If you want to make the End Date dynamic, maybe you need a measure. That depends on your data model.
One more thing, maybe using the Start Date in a slicer is a bad idea. It will filter down (hide) the unqualified records. The Start date of Azure is 15.07 that is smaller than the left value of the slicer. That's why you can't see Azure in your table.
Best Regards,
Dale.