Forum Discussion

lpakhomova's avatar
lpakhomova
Regular Visitor
4 years ago

Values for Datetime showing as Date, but act as Datetime

Using Tabular as a source for the report and values with datatype = datetime appearing as date in the reports, but act as datetime when used in a table and doesn't group counts and sums. For example, I have count of 13 accounts and for March 13, it shows 13 rows for March 13, each row has count = 1. I found a work around showing Date in a table but casting as Date, but I still need to show each account with timestamp and it shows as date and not time. This looks like a bug

Need Help

3 Replies

    • lpakhomova's avatar
      lpakhomova
      Regular Visitor
      4 years ago

      Thank you ryan_mayu. It does not work, the datetime value is not visible, the source is Tabular and not all values visible in formulas all the time. The visitbility depends on the function and int() only can see calculated measures and not the valuies that come from the Tabular. And also I how do I get to show datetime format in a table? This issue seems to exist only when the source is Tabular

  • awff's avatar
    awff
    Icon for Helper III rankHelper III
    4 years ago

    I've had a similar issue in the past where a DAX measure wasn't recognising a column as date data even when the data type was changed in the modelling view.

    I had to also go into power query to change the data type as well.