Average per company

[ThatNewGuy]

It's my first day using Power BI.  I'm a moderate level user of excel, and I would normally use pivot tables to pull the information that I need, but we've been asked to move our dashboards over to Power BI, so I'm jumping into the deep end.  I know this is probably in search somewhere, but I'm so new I spent an hour searching and don't know if I'm just not asking the right question, or don't understand the answers. 

I have a very large excel table of all the receipts from our suppliers, and a calculated field that determines if they were late or on time based on the expected and actual delivery dates.  The calculated column is populated with "100" if on time, "0" if late so I can get an average on time delivery easily.  I have included an example of what my table looks like, and another view of what I am trying to get to in Power BI.  Any help or links would be helpful.  Thank you in advance.

[ThatNewGuy]

Supplier Name	Purchase Order	Expected Delivery	Actual Delivery	Late?
A company	1001	7/7/2022	7/7/2022	100
B company	1002	7/12/2022	7/10/2022	100
B company	1003	7/13/2022	7/22/2022	0
A company	1004	7/14/2022	7/16/2022	0
D company	1005	7/15/2022	7/15/2022	100
F Company	1006	7/16/2022	7/19/2022	0
A company	1007	7/17/2022	7/17/2022	100
B company	1008	7/18/2022	7/11/2022	100
B company	1009	7/19/2022	7/25/2022	0

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[ThatNewGuy]

Yes, this helps a lot.  I appreciate your help.

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur]

Hi,

Share the link from where i can download your MS Excel file.

[ThatNewGuy]

I cannot share a link online, does the table I added help?