Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ankitachelani
Regular Visitor

Count of customers active between 2 dates

I have a data with customer Names and their active seasons (basically months), as per the form they have filled.

Ankitachelani_0-1718266003365.png

 

According to this information, Customer A is active from February till October (both inclusive) but not active in January, November and December.
Similarly, Customer C is active from August (Current year) till May (next year) and not active in June and July.

 

I would like to create a chart with month names on x-axis and the number of active customers in that month on the Y-Axis. 

 

For example, in month no 6 (i.e., June), 3 out of 4 customers are active and in month no 1 (i.e., January), 2 out of 4 customers are active.

 

How do I achieve this in Power BI Desktop with a Direct Lake model? All my data ingestion and modelling is done on Fabric.

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @Ankitachelani,

It seems like a common multiple field range analisis requirement, you can take a look at the following blog start, end date part if this help for your scenarios:

Before You Post, Read This: start, end date 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

HI @Ankitachelani,

It seems like a common multiple field range analisis requirement, you can take a look at the following blog start, end date part if this help for your scenarios:

Before You Post, Read This: start, end date 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.