[HELP] How to visualize the inflow and outflow of customers and sales with DAX

[Anonymous]

Hello Power BI Experts,

I want to make a combo chart of a stacked column and line chart for the subscription model business.

Chart 1: The number of new customers, lost consumers, and the net number with slicer by country
Chart 2: The sum of new sales, lost sales, and the net sales with slicer by country

Client Code	Sales	First Subscription Date (EOM)	Last Subscription Date (EOM)	Country
1000	1.59	3/31/2020	11/30/2022	Germany
1000	2.58	3/31/2020	11/30/2022	Germany
1001	2	3/31/2020	4/30/2020	Japan
1002	10.41	9/30/2022	11/30/2022	Italy
1007	17.07	3/31/2020	11/30/2022	France
1007	22.96	3/31/2020	11/30/2022	France
1007	27.76	3/31/2020	11/30/2022	France
1008	16.74	3/31/2020	11/30/2022	Hong Kong
1013	3.2	3/31/2020	9/30/2020	Brazil
1014	59.98	4/30/2020	6/30/2022	Japan
1014	61.98	4/30/2020	6/30/2022	Japan
1015	2	3/31/2020	11/30/2022	Indonesia
1017	4.39	3/31/2020	11/30/2022	Thailand
1020	4.59	3/31/2020	11/30/2022	South Africa

I have managed to identify the first and last subscription dates with DAX, but I'd like to know how to proceed with the next. Any advice on DAX would be appreciated. I appreciate any help you can provide.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Not sure. Calculates the minimum date under the current filter table and country that is greater than the current date.

Please try this:

Nextdate = CALCULATE(MIN('Table'[Date]),'Table'[Country]=MAX('Table'[Country])&&'Table'[Date]>MAX('Table'[Date]))

If this does not work, please consider providing sample data and expected output.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Anonymous]

@Anonymous  Thank you, I have managed to solve the issue based on your idea!