Forum Discussion
jusTodd
1 year agoAdvocate IV
Latest Date Inconsistency between Text & Card
Trying desperately to understand why I am getting to different dates from the very same column in a table, through 2 different visuals. Visual One > Adding a Text Box with "Value" that is "Latest...
- 1 year ago
Hello, jusTodd ,
depends on how you use it, but perhaps sometimes it's sorted based on the text value, sometimes on date value, which will differ mostly likely.
I recommend just creating measure from your column, like MAX('table'[Column]), then you will get consistent values.
vojtechsima
1 year agoSuper User
Hello, jusTodd ,
depends on how you use it, but perhaps sometimes it's sorted based on the text value, sometimes on date value, which will differ mostly likely.
I recommend just creating measure from your column, like MAX('table'[Column]), then you will get consistent values.
jusTodd
1 year agoAdvocate IV
Thanks vojtechsima ! That is a great piece of advice and exactly what I shall do.