Forum Discussion

willia93's avatar
willia93
Regular Visitor
5 years ago
Solved

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.

  • Anonymous's avatar
    Anonymous
    5 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

  • Anonymous's avatar
    Anonymous
    Not 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

    • willia93's avatar
      willia93
      Regular Visitor

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