Forum Discussion
Creating a column with DAX
I'm new to Power BI. I'm trying to create a column that gives me the total calls each agent received by date. On 3/5/2023 Dee took 2 calls. I appreciate any help. Thanks
| Call Start Date | Agent Name |
| 3/2/2023 | Cici |
| 3/2/2023 | Dee |
| 3/5/2023 | Dee |
| 3/5/2023 | Dee |
| 3/5/2023 | Cici |
| 3/5/2023 | Eric |
| 3/7/2023 | Dee |
| 3/7/2023 | Eric |
2 Replies
jengnz , Simply create a visual with name, date, and a measure = countrows(Table)
You can filter/slicer on date, and have a visual name and measure = countrows(Table)
I have the visual of the total calls by date and agent but they would like to see the data in a table with a column for the total calls for each agent by date.
