How to write DAX formula for Filter based on Dates in Power Bi

[nanat]

Hi guys,

I require some help ASAP.

I have 2 set of dates - Customer Commencement Date and Customer Order Date (when they order products). I am trying to get the total number of signed customers based on the order dates. We have new customers signing up everyday so the total number of signed customers should change according to the order dates.

Thanks.

[ChandeepChhabra]

@nanat : Could you please share a sample of your data and the expected result ?

[nanat]

@ChandeepChhabra: thank you for your reply. I am trying to get the number of active customers (below graph, grey bar) based on their service commencement dates to change according to the year-month of ordering dates. At the moment, the number of active customers remain static. My current measure to get the number of active customers is:

Active Customers = CALCULATE(DISTINCTCOUNT(AllCustomers),AllCustomers[Status]="CUSTOMER-Signed"||AllCustomers[Status]="CUSTOMER-Free Trial")

I have no idea how to add in conditions to look at the commencement dates of these active customers and change according to the year-month of order dates. Thanks.

[ChandeepChhabra]

@nanat Can you send me a sample of your data? I need to take a look at it