Forum Discussion
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 Calendar Date"
... this one sometimes works the first time, but rarely moving forward
Visual Two > Adding a Card using "Latest Calendar Date
... this one is consistent
It would be nice to be able to rely on the Text "Value"
As mentioned, I am using the very same column from the very same table for each of these.
Any thoughts?
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.
2 Replies
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.
Thanks vojtechsima ! That is a great piece of advice and exactly what I shall do.
