Active Count of Table with Start and End Date by Year

[stack23]

I have a customer database table that contains their active date, say for a bank account open:

1. CustomerRecord
2. Customer Name
3. Start Active Date
4. End Active Date (Blank willl be active)

I would like to create a chart which lists Cutomer Count Active By Year.  See below.

How would I do this in Power BI? I know how to do this in SQL scripts.

Just FYI, this table has around 5 million rows.

CustomerRecordId	CustomerName	BeginDate	EndDate
1	Tom	3/1/2012	5/7/2018
2	Michelle	8/3/2015	12/1/2015
3	Joe	6/14/2014	2/9/2018
4	Emily	11/16/2016	8/24/2017

[v-chuncz-msft · Accepted solution]

@stack23,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Create-date-Parameter-asat-date-to-get-active-customers/m-p...

[stack23]

this only shows 1 date, I want to generate a chart above, that will show a trend analysis with multiple dates, given my customer table

Maybe, I want to select a range of date 1/1/2012 to 1/1/2018, and it will show annual year axis, with customer counts by year

[v-chuncz-msft]

@stack23,

It is similar. Just change to year accordingly.