Forum Discussion
Finding Bills & Qty Outlets
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 Anonymous Sujit_Thakur
Hi, Anonymous
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.
Hi Anonymous ,
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.
8 Replies
Hi, Anonymous
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.
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.
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.
Hi Anonymous ,
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.