Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a customer database table that contains their active date, say for a bank account open:
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 |
Solved! Go to Solution.
You may refer to the following post.
You may refer to the following post.
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
It is similar. Just change to year accordingly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |