Why does a column with data return (Blank)?

[Kimber]

I have a column in my table that is a datetime. Every row in the table shows the same datetime. But when I try to display the Latest datetime, it returns blank and I have no idea why. Can anyone help?

 

[rajendraongole1 · Accepted solution]

Hi @Kimber -can you check in Model" view, select the column, and check that the Data Type is set to Datetime. If it's not, change it to Datetime. similarly check at power query editor the column with the datetime values and inspect the values there to ensure they are consistent and correctly formatted.

create a simple measure by referring the column and table replace as per your model 

Latest Date Test = MAX(TableName[DatetimeColumn])

Create a simple card visual and add the Latest Date Test measure to see if it returns the expected value.

If it still returns blank, consider testing in a different report page.

Hope the above details helps.