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.
Hi all,
I have posted this question before but after some research and tips from the community I can explain the problem better.
I have a line chart that shows my active clients per year and month. The problem is that the chart only shows how many new clients I gained that year/month and not the new total.
So I need a formula that calculates when a client is active by looking at start agreement and end agreement. Now I depend on the agreement state column.
So the question is: Which Syntax(es) should I be looking at?
Because I know what needs to happen but I don't know how to do it.
This is the formula I have now:
Active clients =
CALCULATE(
COUNT('Clients'[Client Code]),
FILTER('Clients', 'Clients'[Price Agreement State] = "active"))
Sample data:
Client Code | Price Agreement State | Start Agreement | End Agreement |
2016022347 | ended | 25 February 2019 | 25 February 2020 |
2015081980 | ended | 20 December 2019 | 20 May 2020 |
2019073579 | active | 01 August 2019 | 01 August 2022 |
2016062578 | active | 23 January 2019 | 23 January 2021 |
2016032399 | active | 10 March 2019 | 10 September 2021 |
2017022778 | active | 01 March 2020 | 01 March 2025 |
2019073570 | active | 02 September 2019 | 02 September 2021 |
Thanks for the help in advance!
This appears to have been resolved:
Proud to be a Super User!
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
53 | |
46 | |
15 | |
12 |