Forum Discussion
Count Days from a Table
Hello, I have a requriement to capture how many days a rep is active per month. The rep can have multiple rows in a single day as there are other fields (such as status and categories etc). ...
Hello to PBI5851,
There are two ways to get the effect of your question request:
1. Create a column
Month_day =
CALCULATE(DISTINCTCOUNT('Table'[Date]),ALLEXCEPT('Table','Table'[Rep]))Result:
2. Create a measure and form a card to view it.
Measure：
Count = DISTINCTCOUNT('Table'[Date])Form a Rep-based cutter and a custom-based Card:
Result:
Best regards
Liu Yang
If this post helps,then consider Accepting it as the solution to help other members find it faster.