Date and Time - Tickets not adding up

Power BI Data Model
2

Hi @chad.sharpe,

Few remarks about the model.

  • Your Date table wasn’t marked as a date table
  • Your relationship in the fact table was on the [Created Date] field (which is a type date and time) not on the [Created Date - Date Only] field which is a date type field. That’s why no Month & Year values showed once corrected this is the result…
    image
  • the [Created Date - Time Only] needs to be set to a time datatype
  • add a Time dimension table to your model
  • Lowering the granularity of the Time column by removing seconds, you can achieve as follows: Time.From( Time.ToText( [Time], “hh:mm”))

In the M code showcase category you can find code for a Time dimension table.

for example

image
image489×596 7.8 KB

Here’s your sample:
Date and Time Support.pbix (199.9 KB)

I hope this is helpful

2 Likes