powerbi desktop

  1. S

    Creating a Workbook with a Series of Macros

    Hi I wanna create a workbook containing all the macros I am likely to need. I will have a table already downloaded and the first macro I wanna create involves adding additional columns from AU with these headings Postcode ID_for_db Firstname_for_db Lastname_for_db Postcode_for_db...
  2. M

    Opening Stock Value

    HI, I am working on Cost of goods sold using Powerbi. https://www.mediafire.com/file/pmb7u1thsag1kq1/Cost+of+goods+sold.pbix/file Above is my file which i uploaded on mediafire. i am taking the average price by using average function year wise. If you see in File. GName Year Opening...
  3. N

    Retrieve Date and Time format from appended queries

    Hello, I am new with PowerBI and not sure if this is even possible. I have a main table/data model which I appended multiple months of data (different tables per month, which I append tables per month). A column on the data model had originally a Date and Time format which I changed the format...
  4. G

    Displaying % in power BI

    My data is structured as below (snippet of data) <tbody> ID Location Status AP001 Location5 Booked AP002 Location3 Pending AP003 Location2 Lost AP004 Location7 Lost AP005 Location4 Booked AP006 Location2 Lost AP007 Location6 Lost AP008 Location1 Booked AP009 Location7 Lost...
  5. T

    Multiple visualizations from one table

    I am very new to PowerBi and have a question about Top 10 rankings by count of model number. I have some large tables that have multiple sites on them like: Boston, New York and Chicago. At each site they will have a list of top 10 models used. Since all of this is in one large table "query"...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top