powerbi desktop

I have an Inventory Walk table that has month on columns and values on rows. Rows consist of Stock on Hand, Total Receipts, Total Demand, and Net Inventory. Stock On Hand is always the current month, then Total Receipts and Total Demand for each month. Net Inventory is a measure that is Stock...

Hello, I have an applicant workflow and would like to measure how long a candidate has spent in which status (per job and average across all jobs). I want to visualize it in PowerBI. I have the following table: Job Req ID Application ID Application Status Application Status Category Created...

I'm trying below power query to pull data from WebApi but it's throwing error. It's working fine in Postman. Any help would be appreciated. Thanks Body= [ #"apiKey"= "<ApiKey>" ], webdata = Web.Contents("https://api.website.com/api/Profile/GetAllProfiles"...

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...

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...

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...

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...

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"...