 Hello everyone and welcome back to another video. So in this video, I've actually upgraded some technology and invested in a new microphone So hopefully you can hear me a lot clearer and obviously if you do prefer it Please do make sure you give this video a like just so I can see straight away Hopefully I'll say I had a few comments previously where they're saying that the sound was maybe a bit too low or wasn't that clear So hopefully this new microphone has rectified that issue So just to start the video off on a high one But other than that we're starting at this video still looking at power bi so we're continuing our power bi series And we're going to be taking a look at again Just more ways of working with data within the tool what I have done is I've created or well I'm not creating a new file. I've just extended Upon the file we were using previously. So I've just added a lot more data to it That will just give us like say more data about to play with and it just makes a bit more meaningful and More content about to do stuff with within the power bi application So you can find the link to delam delam to download that file in the Description for this video and also if you haven't downloaded the application before or you're new to obviously power bi We've also retained the link to download the application in the description as well So you should have anything you need to carry on with to follow along with what we're doing here today So what we're going to just do is we'll start looking about how we'll focus this video around playing around with Numbers, but specifically within tables and the benefit of this is once you've got the idea of how You can use these different ways of displaying numbers You can apply it to everything and anything when it comes to you obviously summarizing data in power bi So following on from what we had before and obviously your notice There's a lot more data here and specifically for other countries as well just rather than the UK So I was going to move this table over to the side just so we can see a bit clearer So at the moment we've got a summary at city level All I'm going to do is just get rid of the total units and actually want to get rid of city as well Go back into our locations column and let's just pull country in because that gives a bit of a higher level For working with these numbers. So at the moment, obviously we're working with country and you can see Actually, what we could do is yeah, let's stick with country because we only got a few here And then what we've got in this other table. Let's just change that to rather than name Let's put in their city and hopefully we're going to start building something meaningful get rid of the units Okay, so we can see we've now got two tables So we've got one for country and one for city in both table The number of sales on the side here is obviously the total sales that was generated for that either country or city So for France, obviously if we clicked on our France or our total sales over here You can see that it's now filtered our city table So we can see that how that that total of 453,000 is broken down into obviously the values per city So we can see all the cities that accumulated to give us this total for five four three thousand So at the moment, obviously it gives us the numbers we need But we want to just try and tie this up a bit just so the formatting is a bit more correct What I'm going to do is over the left or the right hand side I just say in the sales table and just click on the total sales field And then what I'm going to do is go up to the top in you can see it's already gone there for us But we can go into our tools that we've got open here So I think we've just gone into Column tools and then what I'm going to do is rather than have a whole ball Actually, we're going to leave it as a whole number But I want to show a monetary amount So what we can do is we again very similar to what we have available to us in Excel We're able to format obviously the numbers in there. So what we could do we could either change this to a Currency and if I click that currency drop-down, you can see all the currencies I have available So I'm just going to change this to English in the United Kingdom And then as we let that just work its magic You can see it's all automatically updated the formatting for that field so we can now see it in like I'll say a currency If however, we didn't want it in like the currency that we've got there We could just do it into commerce and separated what basically gives the same thing If I click it again, if we do basically the same thing it just won't give us a currency amount So we have that option as well and lastly the ones we're looking at is we've got decimal place So if I click this decimal place button here, I think it's clicked Yeah, let's try one more time. Oh, no, it's not going to work because obviously you've got a whole number Let's say if you're going to a decimal decimal number can't speak and then we want to now go Yeah, great. Thank you very much and let's say we want the player the decimal places I was put one on there You can see that we can now play around with like decimal places if we had pence in there But actually the numbers we've got in there are actually whole numbers themselves So there won't be any decimal numbers to display But what I want to do is to divert back to the English United Kingdom Cool. So again, as we said to start this number at the moment is just giving us the total number of sales That were generated for the country and the city But let's say rather than looking at the actual sales amount You want to see how many sales were made in each country? So in order to do that, all we need to do is select our required table And all we need to do is go to total sales and you'll see this little drop down just to the right-hand side If you select that drop down, you can see all the options we have available to us So we have some average minimum maximum count Count distinction I say count and a couple others in there as well So let's say we want to the count the no total number of sales that we had in France All we need to do is select the count option and you can see with now Oh, let's move it to the side. We can see we can there was a total of a hundred and fifty-five sales in France What a mass to obviously whether that total was so if I click France Yeah, we can see there's a total of a hundred and fifty-five sales Obviously, which obviously generated that total of four hundred and fifty-three To demonstrate in this city column what we can do as well It say we wanted to have obviously that total Sales amount as in like the number of the pounds total We can also bring tech. We can also duplicate. Should I say that sales column? So rather than having just once we can bring in total sales twice So you can see we've got total sales and total sales We're currently showing the same but let's say in this one We wanted to do as we just now looked at the count we can do that and from exactly that same field So without having to do any other Additional fields or trying to do any calculations. We're very a easily able to now generate a total sales And obviously how many sales generated that total and to be fair This is actually an easier way of doing it rather than what I was doing before by trying to do it separately So let's move that to the side And let's maybe just move this and change that back to that maybe our sum And we'll just expand this table if I can click in it. Yeah, there we go So you bring that over so we've got some more space as well And let's say now, okay We've got our total sales amount and we've gotten how we know how many sales it took to generate the total sale Well, what was the actual average sale amount? So obviously within Barcelona there was obviously a number of sales generated So what we could do is we can now say let's bring total sales in again But this time we're going to select the average And you can see that again we've now got the average number of sales What in essence is obviously going to be the total sales divided by the number of sales But this just gives us the ability to just see that obviously at a quick again without having to do any calculations It's all built-in functionality that we have available to us straight out the box At the moment, obviously, we've got these are two additional fields But it can get a bit complicated but trying to work out Well, we can clearly see what each column relates to because we've just done it But let's say someone's now going on here They probably aren't going to understand what this is relating to other than obviously the count of total sales What we can do if we want to rename that column heading is we just go into our applicable fields So count of total sales click our drop-down and then select rename And now we can call call it whatever we want to do. So we can say number of sales And hit enter and you can see it's now updated into that header for us And if you wanted to do into here we could go average sale or Anything that you want to call it and what happens when you rename these column head or these fields here It's not applicable to any other Table it's only going to update the column headed in your particular table you're updating and obviously it's not going to Change or affect the actual column header of that field in its actual table where it resides So we've obviously got these two options here at the moment What we looked at of counting the number of sales and how to also look at the average as well Let's say however, we wanted to look at the minimum maximum sale So what was the smallest sale done in Barcelona and what was the maximum done in Barcelona? We could add more fields, but I'm simply going to just change the ones that we're currently got in here already So what we're going to do is go number of sales and select minimum and let's go rename smallest sale and we'll change the other one to again Thing I say again lack of words what the thing to put there So let's go smallest sale and we did do that yet We had minimum and let's go into this. Oh just removed it So I'm going to control Z to bring that back and the largest sale should be maximum so we can now see and Probably not well no surprise really to myself Because all these were randomly generated numbers, but as you can see they're all fairly similar But again minimum maximum is another beneficial one that we could be using when we're trying to analyze this data So I hope you enjoyed that video as bit of a well probably wasn't that short after all actually But it's just another one to show you a bit more how to work with data in power be I Obviously, this is really benefit of us. Well, I say obviously working with tables probably isn't the most visually appealing If you wanted to use charts or your audience is more wanting to see charts But it's really beneficial to understand how you can use tables to really sort of navigate through your data As we sort of touched on the stamp the benefit of using two tables like this of different levels in a particular hierarchy Such as location is it gives you the ability to drill down into each one So obviously we had countries so if you want to go into Great Britain You can go into Great Britain and then straight away see obviously how the sales or Great Britain are broken down and just straight away Okay, smallest and largest might not be the most interesting to look at this But you can then start to actually sort of interrogate your data and really understand what the number What are the numbers behind the graphs? So let's say hope you enjoyed that video just trying to cover off numbers and formatting in particular If you haven't subscribed already, please do subscribe to the channel And if you enjoyed that video, don't forget to give the video a thumbs up and likewise if you've got any questions at all Please drop me a comment below this video and I'll get back to you as soon as I can So thank you very much for watching and we'll see you in the next video