advice on data

I have created a working example pbx file for you showing step by step how you can take youe excel file and make it work in PowerBI.

Datawise at a minimum I suggest you transpose your data from this

To this

You can do this with special paste in excel and select transpose.

Better still you would have

Once you have your data better set up the powerbi side is easier.

In the example pbx file I also created a seperate date table by merging the salesperson and location tables together, removing everything except the dat and then deleting duplicates.

This allows you to add a date filter that will show all dates that appear in either the sales person or location tables.

Even better would be to create a date dimension but given you are just starting out what I have described above is easier for now.

If you want the example pbx file then just private message me your email address and I will send it over.

Hope this helps.

If so please click the botton to accept this as an answer.

Thanks.