Forum Discussion
undefined
I have this table of data .
I need to calculate
1. Number of orders
2 . Number of vic orders
3. Number of orders in each office
4. Number of vic orders in each office
1. Number of orders duration less than 2 hour
2 . Number of vic duration less than 1:30 hour
2 . Number of vic orders 1:30 hour
1. Number of orders over 2 hour
2 . Number of vic orders 1:30 hour
1. Number of orders over 6hour
2 . Number of vic orders 2 hour
Outcomes in table
Orders orders less than 2 over 2 over 6
Norm
Orders orders less than 2 over 2 over 6
Vic
And if can do some graphics line its good to
I have tabe in excel but i dont know how to attach it
Hi Eng-mohd
Please provide the sample data and show the desired result.
Link to the explanation about providing data :
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216You can also share a public link to the pbix / excel that you save in some kind of drive
2 Replies
- Ritaf1983Super User
Hi Eng-mohd
Please provide the sample data and show the desired result.
Link to the explanation about providing data :
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216You can also share a public link to the pbix / excel that you save in some kind of drive