consecutive days profit or loss for client

[Sriku]

Hi,

I want to pick only those client who made profit in consecutive days 3 or more 30 days(date range should be dynamic)

Row ID	Order Date	Customer Name	Profit
1	11/8/2018	Claire Gute	41.9136
2	11/8/2018	Claire Gute	219.582
3	6/12/2018	Darrin Van Huff	6.8714
4	10/11/2017	Sean O'Donnell	-383.031
5	10/11/2017	Sean O'Donnell	2.5164
6	6/9/2016	Brosina Hoffman	14.1694
7	6/9/2016	Brosina Hoffman	1.9656
8	6/9/2016	Brosina Hoffman	90.7152
9	6/9/2016	Brosina Hoffman	5.7825
10	6/9/2016	Brosina Hoffman	34.47
11	6/9/2016	Brosina Hoffman	85.3092
12	6/9/2016	Brosina Hoffman	68.3568
13	4/15/2019	Andrew Allen	5.4432
14	12/5/2018	Irene Maddox	132.5922
15	11/22/2017	Harold Pawlan	-123.858
16	11/22/2017	Harold Pawlan	-3.816
17	11/11/2016	Pete Kriz	13.3176
18	5/13/2016	Alejandro Grove	9.99
19	8/27/2016	Zuschuss Donatelli	2.4824
20	8/27/2016	Zuschuss Donatelli	16.011
21	8/27/2016	Zuschuss Donatelli	7.384
22	12/9/2018	Ken Black	5.0596
23	12/9/2018	Ken Black	15.6884
24	7/16/2019	Sandra Flanagan	-1.0196
25	9/25/2017	Emily Burns	240.2649
26	1/16/2018	Eric Hoffmann	4.2224
27	1/16/2018	Eric Hoffmann	11.7741
28	9/17/2017	Tracy Blumstein	-1665.0522
29	9/17/2017	Tracy Blumstein	-7.0532
30	9/17/2017	Tracy Blumstein	15.525
31	9/17/2017	Tracy Blumstein	1.1016
32	9/17/2017	Tracy Blumstein	9.7092
33	9/17/2017	Tracy Blumstein	-5.715
34	9/17/2017	Tracy Blumstein	3.546
35	10/19/2019	Matt Abelman	9.9468

[amitchandak]

@Sriku , Have created a blog on similar topic Continuous-Streak , see if this can help. Need to consider how the streak is created

https://community.powerbi.com/t5/Community-Blog/Power-BI-Continuous-Streak-With-More-Than-a-One-Day-...

[Sriku]

In my case I have only one date order date. How to build the consectuive date 3 days and flag as profit or loss for each client.

Do we need end date as well to follow your blog? My requirement let assume for month of Aug(30days) I need to flag client as profit and loss for consecutive 3 days. Is the logic as per the Blog.

Regards,

Srikant

[Anonymous]

Hi @Sriku,

What's your desired result? Do you want the customer names who are got the profit or loss? As checked your sample data, every customer have profit value only in one date. So which date do you want to calculate the profit value of consecutive three days base on? Please provide your desired result in form of table or screen shot and the calculation logic of your requirement. Thank you.

In addition, I created a sample pbix file for you. Please check if that is what you want. You can also refer the following blog to do it.

Lost Customers DAX Calculation for Power BI

Best Regards

Rena