power bi

Hi Is there a way in power bi to calculate the Monday's covered between two dates, if annual leave or sickness cover more than 1 week? I have also asked if it is possible in Excel, but then Power Bi, came to mind as well. Thanks for any advice. ABCDEFGHIJK1Absence CategoryAbsence Start...

Is it possible to create a new table based of multiple column of an existent table, but replacing the values that are negatives to zeros?

Hi all, I have data that I have been taking care of through Power BI and I need this data in Excel now. The easiest for me is to have this data in a Pivotable, so my aim is to create a pivotable in Excel with the data I worked on through Power BI. thanks ! N.B.: cross posted Create a...

Hello all, I have the following DAX Measure: Total Deplaned Cargo = VAR TotalDeplaned = SUM(Cargo_Numbers[Ameriflight Deplaned]) + SUM('Cargo_Numbers'[American Deplaned]) + SUM('Cargo_Numbers'[Southwest Deplaned]) + SUM('Cargo_Numbers'[United Deplaned]) RETURN...

Can someone figure out what is wrong with my code? Purpose of the code: If the column Brand is filtered and SKU is not --> value sales of 2022 of the whole brand with all SKUs If the column SKU is filtered --> value sales of 2022 of a specific SKU If no filters --> value sales of 2022 of all...

Hi everyone, I want to make operations through Power Query. I am a rookie but I almost succeeded reaching my goal here but now I am stuck. I have 5 columns which gives for each technician, type of hours spent (work, holidays, ...), the number of hours spent, the date when it was spent and the...

I have the following table in Excel: DATE VALUE 1/1/2024 100.00 2/1/2024 150.00 3/1/2024 200.00 4/1/2024 5/1/2024 6/1/2024 7/1/2024 8/1/2024 9/1/2024 10/1/2024 11/1/2024 12/1/2024 Lets say this table is called Table1. For the Months 4/1/2024 - 12/1/2024...

I am creating a dashboard to display some calculated metrics. I have a detail with thousands of lines of submitted invoices. I have pulled out the Creation Dates, User, and the number of invoices submitted (by day and user), and I am trying to do some user level comparisons. I have been able to...

Hey guys, I Need to create a PowerBI Matrix visualization, which should present number of issues that contain column AND row count value. I'll explain: In the following snapshot, you can see how my DB looks like (on left side): 'issue_id' and 'tags' (which present the issue tags) fields. each...

Hi, Bit of a multi part question as new to PQ and PBI. I have an initial table of data storing audits by location, type, date and the score awarded. There are lots of things I want to eventually pull out/ display from the data but two main things to focus on: 1) Finding the most recent score...

Hello Power BI experts. I have a dashboard tracking hours on various days, among other data points. I am using a SUMMARIZE table function, grouped by the columns you can see in the code below. The only problem I have is that the ClinicHours table does not have any data prior to 1/1/2023. I have...

Hello experts, In my Power BI report I am trying to do a calculation on all rows in a table, then be able to correctly add them up in the subtotal lines by whatever grouping I am using. In my case, the final grouping I have in Matrix rows is 'Calendar'[EOM], which is not being used in the...

Hi I am trying to great an interactive heatmap that will be have the ids listed in the correct square that you can click on singularly and go to another page to see more detail. Is this possible at all? thank you in advance for any help

1-I want to to get Median,Average or Stdv of 4 measures 2-I have 4 columns,Clm1,Clm2,Clm3 and Clm4 I want to create calculated column to get the Median or average of each row of those 4 columns. But the answer should be for DAX, no need power query or excel formulas.

Hi, Can anyone advise or let me know if they've had the same problem, I do not have a create button on the parameters dialog box, is there a way round this? I have uninstalled reinstalled / repair etc. But I have never had one, I tend to use power pivot so it's not a huge problem but there...

I have data as per Image 1 and I need it to return it as a list as per Image 2. So basically the excel file is a Construction equipment workbook with separate sheets for separate construciton equipment. How to do it. I want this data as a list such that it can be used in Power Bi. The data in...

Hello all. I am struggling to figure out what is going on. I have a power bi file that is pointing to a folder, that contains over 70 .csv files. Each file is around 200 Mb. I have been working with the power query editor all day. I finally had what I *thought* was a finished product...

Hi, If I am in Excel I can load a table to power query close add to data model , then go to power pivot, check I have what I want and if it is not right or I have forgotten to do something I can go back to power query make the changes I want and they will be reflected in the power pivot table...

I have Power BI online thru our city. I have a data set that I was working with using Power BI Desktop. When I am using the online app, I tried to refresh the data. I am getting this error: Data source error: Scheduled refresh is disabled because at least one data source is missing...

I have five (5) different files that have .csv files in them. The five folders of information have five different columnar layouts. Is there a tool/trick/workaround in Power Query or Power BI where I can pull the different columns into one worksheet/table that has all the columns that I would...