powerbi dax

  1. C

    (Average) Time in Status

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

    Combine filters and do a summary table based on filtering

    Hi, On the report view I have created some basic drop down lists. Whenever I choose a district and then a municipality I would like to have a summary table on the bottom of the page (please see attached) which will count how many observations I have for the specific district, municipality. I...
  3. Z

    Calculate the attrition for new hired (<= 6 months of hired date)

    Hi, I need to calculate the voluntary attrition for employees who left the company within less than or equal to 6 months of their hire date. How would I accomplish this? I have below fields and tables: - Attrition Table that has below fields: - Employee ID - Hire Date - Term Date - Term...
  4. 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...
  5. Y

    How to calculate the YTD Average in Power BI

    Hi, I'm very new to Power Bi and I learn that from Youtube. I am stuck with the YTD Average. If it was in Excel, it's easy - =Average (), But, in Power Bi, it's a bit complicate. I have two table, one is custom build calendar table - 445 calendar. And a fact table. The fact table looks...

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
Back
Top