Forum Discussion
Distinc count Active Customer from Historical Table by Month
Hi everyone I've been looking around the community for something that might provide an answer to my problem. I have a Table hitorical Customer which display as below and I want to distinc Count C...
Hi,
I am not sure how your datemodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.I hope the below can provide some ideas on how to create a solution for your datamodel.
Customer Count measure: = VAR _t = SUMMARIZE ( FILTER ( CUSTOMER_HISTORY, CUSTOMER_HISTORY[FROM_DATE] <= MAX ( 'Date'[Date] ) && OR ( CUSTOMER_HISTORY[TO_DATE] >= MIN ( 'Date'[Date] ), CUSTOMER_HISTORY[TO_DATE] = BLANK () ) ), CUSTOMER_HISTORY[CUSTOMER_CODE] ) RETURN COUNTROWS ( _t )
Jihwan_Kim
Super User
Super UserHi,
I am not sure how your datemodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Customer Count measure: =
VAR _t =
SUMMARIZE (
FILTER (
CUSTOMER_HISTORY,
CUSTOMER_HISTORY[FROM_DATE] <= MAX ( 'Date'[Date] )
&& OR (
CUSTOMER_HISTORY[TO_DATE] >= MIN ( 'Date'[Date] ),
CUSTOMER_HISTORY[TO_DATE] = BLANK ()
)
),
CUSTOMER_HISTORY[CUSTOMER_CODE]
)
RETURN
COUNTROWS ( _t )
Dear Jihwan_Kim
By refer to your solution, I worked with me, thanks