Forum Discussion
Number Active between two dates
I have data that comes in similiar to this: Customer ID Customer Type Week Active A Type 1 1 1 A Type 1 2 1 B Type 1 1 1 C Type 2 2 1 D Type 1 1 1 D Type ...
Anonymous ofcourse, this is a power bi forum. my question again, is that the output you are looking for?
The ultimate output would result in just the number 4. I have a measure that calculates the total number of customers in both weeks (6). I will be using that measure to show number active (4) / total customers (6) = 67%