powerbi

  1. M

    Count the Number of Sick Occasions in Dax - Calculated Column - PowerBI

    Hi All, I was wondering if anyone know how to count the number of Sick Occasions in Dax? i know how in Excel but dax is a completely different beast. Looking at the example i have posted. I want it to show 0 if they were not absent. Then increment once they become absent. But then they return...
  2. M

    Power BI DAX Rollover Function In Matrix Needs to Factor for Negatives

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

    Is it possible to automatically refresh pivot data extracted from PowerBI?

    Hi everyone I've got an excel sheet with data sourced from PowerBI which is utilised daily however, I'm having to click "Refresh All" under Data every time i use it. Is there anyway to automate the data refresh? The PowerBI data is updated once every morning, if I could align my data to...
  4. 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...
  5. D

    Power BI timeline with milestones

    Hi all, I am wondering if someone is able to help me out to create a visual that would look like this below (I found a topic somewhere else with same request I need today. couldn't find answers about it so I come here to check if there's luck Power BI Stacked Bar as Timeline with Milestones)...
  6. R

    Waterfall Charts in PowerBi

    Hi all, What is the best approach to create a waterfall like this in powerbi? I have no issues preparing it in excel but it won't load in powerbi. Glad to get advise. Data included below; Area/Goal Original Save Spend 2020 Targets 64.0 2021 Target 58.8 Train...
  7. J

    How to correctly calculate the percentage of productivity

    In PowerBI I am calculating the percentage of productivity of each of the technicians who attend tickets, to calculate the productivity of each one I am using the formula "Tickets attended * 100 / Total tickets", to calculate productivity I am creating a new measure where I am executing the...
  8. A

    Help! PowerBI - How to 'COUNTIFS' with conditions

    I've attached a snapshot of my data - I'm looking to count how many shipping addresses a Partner ID has in a list of various Partner IDs. In the image the power BI formula I need is: - For Partner ID# PUS00000111 to show it has 14 'TRUE' shipping address values - For Partner ID# PUS00000342 to...
  9. tazeo

    Efficient Keyword Searching with PowerBI: Tips and Tricks for OR Results

    I often find myself sifting through large amounts of data to identify relevant keywords, and as many of you may know, this can be a time-consuming and sometimes frustrating process, particularly when it comes to spelling errors. To address this issue, I came up with the idea of using PowerBI to...
  10. tazeo

    Adding a Date Column to a Power BI Grouped Table for Monthly Totals by Business Unit

    I have a (successful) query that Groups Rows by a business unit name, and sums a few columns to give totals those units. In a previous step I had already filtered my data to just be one month so I could check my totals against the manual report we use. Now I have opened it up to all the dates...
  11. S

    Power BI - share change at different levels of product hierarchy

    I have 3 markets that account for all sales for current year and last year. I am able to use the % of row calculated field to see the share of each market for each product level, but I am looking to calculate the share change for each market vs. last year for each product level. So for Dept 2 it...
  12. D

    PQ Combine multiple sheets into summary/dashboard

    I have done some basics with Power Query, but I have a need that is beyond my limited skills. So I am turning to my favorite experts here for some help. I have created multiple workbooks with analytics where users input descriptions and amounts for the different accounts. There are 6 identical...
  13. V

    Can u Explain Powerbi rest api AddRows?

    Hi, I'm taking a shot at a real-time dashboard that I can use the PowerB REST API for. My inquiry is how the refresh of the columns works. I have 1300 records stacked once and then 2 sections per column need to be refreshed at regular intervals. The main rest call I see is adding rows, but...
  14. R

    Converting whole number to HH:MM:SS

    Hi! New user to Power BI here and trying to learn how to convert a whole number to a HH:MM:SS format. I've done quite a bit of research but can't seem to find an exact solution online for what I need. I'm currently screening transaction ledgers and the date/time stamp is significantly important...
  15. 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...
  16. S

    DAX query - Looking up (v-lookup) in the same table

    Hi All, Hoping can get some input from the DAX experts here. I have a table imported via power query. It has 2 columns Employee ID - this contains a list of employee IDs Month - this contains 'current month' and 'last month' value Note - The same employee ID can appear twice in the table...
  17. M

    how to get count of subfolders and files on Silcer selection Power bi

    HI before i start, i have also post same concept question on here but for Excel. I am looking the solution for power bi. i do have all folders and files complete path in column ( i fetch data from excel:- data source). from that i have created slicer and i need count of all subfolders and...
  18. C

    Getting latest value from a grouping in Power BI measure

    I am attempting to create a Power BI measure that computes the number of active employees and that can be sliced by date, based on a table that is a running list of employment changes. As a sample data set: Employee ID Change Date Status Title Change Reason A 1/1/2021 Active Director of...
  19. Y

    Relationship not working in measures involving two tables

    Hello! I'm building a dashboard to show the unit cost of Airlines for a school project. I created an index table to show which Cost Category are driven by which Operation Statistics. Here is my measure : Cost/OpStat = DIVIDE('Cost'[Amount measure],'OpStat'[OpStat full Yr],0) When I apply this...
  20. J

    PowerBI replace text query

    Hi Team, I'm stuck with how to replace text in PowerBI. I got one column which contains multiple names with special chars and would like to get rid of all those and just keep it as names separated with ";". Is there an easy way to achieve this? example cell A2 Bage Khiu <57697099.b2wg>;Jonas...

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