Forum Discussion
Matrix only showing earliest/latest date.
I have two IDs connected from two different tables, both have corresponding dates attatched to them, and when I simply to try to put them in a matrix to compare the dates that are attatched, for the one table it is giving me the wrong date that is on the table.
I had to make a measure for the date since the day/month/year were all in different columns. So I am using the new column measure for the matrix, and that is the one that is giving me the wrong date.
When I look at the new column I created it has a date that I want to see on matrix, however when I try putting it on matrix it just makes a either earliest or latest date that I have no idea where it is coming from.
How do I make it show the correct date, the measure new column date.
- Anonymous5 years ago
Hi willia93 ,
Could you please share some sample data(exclude sensitive data) and your expected result with correct logic and special examples in order to provide you a suitable solution? By the way, did you put the date field in Values field option just shown in below screenshot? Thank you.
Best Regards
2 Replies
- AnonymousNot applicable
Hi willia93 ,
Could you please share some sample data(exclude sensitive data) and your expected result with correct logic and special examples in order to provide you a suitable solution? By the way, did you put the date field in Values field option just shown in below screenshot? Thank you.
Best Regards
- willia93Regular Visitor
Anonymous Thank you I was able to fix myself since I had duplicates!