Latest Date Inconsistency between Text & Card

[jusTodd]

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?

[vojtechsima · Accepted solution]

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]

Thanks @vojtechsima !  That is a great piece of advice and exactly what I shall do.