Forum Discussion

krishanw's avatar
krishanw
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   
Need Help
  • Anonymous's avatar
    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

krishanw's avatar
krishanw
Helper II
3 years ago

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

ryan_mayu's avatar
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)