How to group duplicate dates?

[krishanw]

I need to get day wise count, but as per the above image dates are dublicating 

[Anonymous · Accepted solution]

Hi @krishanw,

You can add a calculated column with datevalue function of extract the date part from your datetime field values. Then you can use it as category of matrix to group records.

DATEVALUE function (DAX) - DAX | Microsoft Learn
Regards,

Xiaoxin Sheng

[ryan_mayu]

could you pls provide some sample data?

[krishanw]

Here is the table data. what are the data you need?

[ryan_mayu]

you can try to remove the time in the date and try again

you can do this in pq

or use DAX  = int(column)