Forum Discussion

Kimber's avatar
Kimber
Helper III
1 year ago
Solved

Why does a column with data return (Blank)?

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...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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.

     

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

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.