Finding Bills & Qty Outlets

[Jeevan1991]

Dear Friends,

I have below data set.

Outlet ID	Date	BillNo	Time	Qty
345862	01-Apr-2021	1851	08:50:59 AM	5
509343	01-Apr-2021	6302	09:30:24 AM	4
404274	01-Apr-2021	363	09:32:46 AM	5
404274	01-Apr-2021	1129	09:33:38 AM	6
516222	01-Apr-2021	730	10:10:06 AM	16
516222	01-Apr-2021	6148	10:45:39 AM	18
338801	01-Apr-2021	6237	01:18:00 PM	31
338801	01-Apr-2021	5032	01:46:13 PM	17
444346	01-Apr-2021	3579	02:24:45 PM	15
529276	01-Apr-2021	3920	04:18:51 PM	18
345862	01-Apr-2021	3059	05:10:30 PM	27
529276	01-Apr-2021	5941	06:06:19 PM	30
444346	01-Apr-2021	5585	08:13:49 PM	25
509343	01-Apr-2021	3737	08:48:01 PM	42

I want to find "First Bill of the Day", "First Outlet to Cross 10 Qty in the day", "First Outlet to cross 25 Qty in the day".

Typically i want the result like the below.

First Bill of the Day
Outlet ID	Time	BillNo	Qty
345862	08:50:59 AM	1851	5

First Outlet to Cross 10 Qty
Outlet ID	Time	Qty
404274	09:33:38 AM	11

First Outlet to Cross 25 Qty
Outlet ID	Time	Qty
516222	10:45:39 AM	34

Please help me on this.

@amitchandak @parry2k @Geradav @PhilipTreacy @Kinjal @Sujit_Thakur 

[Jihwan_Kim · Accepted solution]

Hi, @Jeevan1991 

Please check the below picture and the link down below that is the sample pbix file.

All measures are in the sample pbix file.

https://www.dropbox.com/s/qabwy9d8zntksew/Jeevan1991.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[Icey · Accepted solution]

Hi @Jeevan1991 ,

Please check the attachment:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jeevan1991]

Hi Icey,

Thank you so much for your time and help.

This is working for me. Thank you so much.

[Jihwan_Kim · Accepted solution]

Hi, @Jeevan1991 

Please check the below picture and the link down below that is the sample pbix file.

All measures are in the sample pbix file.

https://www.dropbox.com/s/qabwy9d8zntksew/Jeevan1991.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[Jeevan1991]

Hi @Jihwan_Kim 

Technically this result is fine but i need result in 3 different tables.

Like i have posted in the previous post.

And also if the data keeps adding day by day, for the latest date it haas to calculate the result.

[Jihwan_Kim]

Hi,

check  the below link

https://www.dropbox.com/s/qabwy9d8zntksew/Jeevan1991.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[Jeevan1991]

Hi Jiswan,

It is working but this is not working when we have more than one day data.

Can you please apply the smae logic by adding next day data and this data will be keep adding as the days goes on.

[Jihwan_Kim]

Hi,

please check the below link, if it is working as you expected.

In the initial sample data, all the dates are the same.

Now, I assume that the situation is changed.

I also assumed in the sample pbix file that the cumulative counting is reset every day.

I hope I understood correctly.

https://www.dropbox.com/s/qabwy9d8zntksew/Jeevan1991.pbix?dl=0

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[Jeevan1991]

Hi Jihwan,

you are correct every day cumulative total should get change and based on this my result also should change.

Technically for the latest sales data my results should appear. Please add another day sample data and test.

The attached power bi file still giving me wrong result.