Matrix only showing earliest/latest date.

[willia93]

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.

[Anonymous · Accepted solution]

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

[willia93]

@Anonymous Thank you I was able to fix myself since I had duplicates!