Forum Discussion

Helper II

3 years ago

Solved

How to group duplicate dates?

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

Anonymous
3 years ago
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

4 Replies

ryan_mayu
Super User
3 years ago
could you pls provide some sample data?
- krishanw
  Helper II
  3 years ago
  Here is the table data. what are the data you need?
  - ryan_mayu
    Super User
    3 years ago
    you can try to remove the time in the date and try again
    
    you can do this in pq
    
    or use DAX = int(column)
Anonymous
Not applicable
3 years ago
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