Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
80 | |
67 |