Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Need help summarizing the date

I have a data set as follows with multiple orders with same date but different time stamps and when i am creating a table visual to calculate day-by-day sales or cumulative sales, I'm getting the out...
  • johnt75's avatar
    1 year ago

    If you don't need the time part of the order date for anything else then get rid of it. In Power Query change the type to be date rather than date time. Its important that you change the type in Power Query and not just in Power BI Desktop, as otherwise it will retain the time information.

    If you do need the time part for other reporting then create a new column in Power Query by extracting just the date part, and use the new date column to link to your date table or in your visual.

  • danextian's avatar
    1 year ago

    Do as johnt75  said. Even if you use a separate dates table and relate it to your fact table, you'll only see blank rows because the relationship is between a date column and a datetime column. Splitting a datetime column into separate date and time columns or keeping just the date can reduce the cardinality and improve the efficiency of your data model.