Forum Discussion

Berrcikk's avatar
Berrcikk
Frequent Visitor
2 years ago

Group by Date, without Timestamp

Hi all, I'm experiencing a problem with grouping data, which contains also timestamp. Currrent situation is presented below, as you can see, data is not summed up for the same day, due to having tim...
Need Help
rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi Berrcikk - Create a measure to sum the Sum column based on the extracted date part.

Try below measure :

TotalByDate =
VAR currentDate = MAX('Sales'[Date].[Date])
RETURN
CALCULATE(
SUM('Sales'[Sum]),
FILTER(
'Sales',
'Sales'[Date].[Date] = currentDate
)
)

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Berrcikk's avatar
Berrcikk
Frequent Visitor
2 years ago

Hi rajendraongole1 thanks for your response, however as I mentioned, I get the error that the column I'm referring to (with .[Date]), doesn't contain any date, alhotugh this column is set up to Date format.

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi Berrcikk - sty is any language-specific abbreviation? is that a month?

     

    if yes, we have to do in query editor with corresponding months for all 12 months and bring the date format with some other approach.

    check it.

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!