Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to get day wise count, but as per the above image dates are dublicating
Solved! Go to 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
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
could you pls provide some sample data?
Proud to be a Super User!
Here is the table data. what are the data you need?
you can try to remove the time in the date and try again
you can do this in pq
or use DAX = int(column)
Proud to be a Super User!
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |