sorry if the title is missleading or wrong.
I have the dimension Project where i have for example Project 1, Project2, Project 3.
Every Project consits of around 1000 tickets.
I have a custom field: Contract Final Date.
This field will be filled out once in every project.
What i need is now a simple table showing me:
Project | Contract Final Date
I tried by i could not find any solution.
Please help me out of this.
You could import the Contract Final Date as a measure. Then we can find all Time members that have the measure Issues with Contract Final Date and get the last one of them.
Try the following formula (please note the capitalization and spelling of the measure) formatted as a date
[Measures].[Issues with Contract Final Date] > 0
Lauma / email@example.com
thanks for your answer. I already had almost the same solution. But your approach worked. Thanks for your help! I really appreciate your feedback.