Showing the data through power BI using few SQL data tables

Hi, I'm just beginning using PowerBI and was wondering is it possible to show me the data I need. I have 2 SQL tables: So as you can see 1st table contains ALL UK companies with: Nu...

Need Help

Show and Tell

Anonymous
5 years ago
Anonymous this should be relatively simple.

Create a 1-many relationship between "All_Luton_Postcodes" and "BasicCompanyData" on the PostCode→RegAddress_PostCode.

Then in the report, use a date slicer on "Incorporation Date" to filter by the dates desired, and a slicer on "LocalAuthrityName" to filter to the locale desired. Then add a table or matrix visual showing the desired information (CompanyNumber, IncorporationDate, Postal Code, etc.)