Forum Discussion
Count distinct dates against unique User name
Supposing your table named Data, try to create a new table with the code below:
Table =
VAR _table =
SUMMARIZE (
Data,
Data[Date],
Data[Agent Name]
)
RETURN
ADDCOLUMNS (
_table,
"Count",
CALCULATE (COUNT(Data[S. No]))
)
Super UserSupposing your table named Data, try to create a new table with the code below:
Table =
VAR _table =
SUMMARIZE (
Data,
Data[Date],
Data[Agent Name]
)
RETURN
ADDCOLUMNS (
_table,
"Count",
CALCULATE (COUNT(Data[S. No]))
)
I am try same funcation but not getting result, When I am try to add same then I am getting error for multiplace time coulumns cannot be conveted.
My problem is
I have data when we have many member and those worked on many task on same on different date. Now I want to count number of days by members So could please guide me how I can add measure to find out number of days work by members?