Value has been changed After unpivot the columns in power Query
"My input source is an Excel sheet named 'Source-Reduced'. This sheet has been configured in Power BI. I am attempting to unpivot the following columns. Total 2024 OB Total 2023 RF9 Total 2023 RF6 TOTAL RF3 2023 OB23 Total 202 Before input, these columns show correct values as per the Excel sheet. After unpivoting, two columns are created: 'Attribute' and 'Value'. When I select a particular attribute column, the values appear significantly higher. Before unpivoting, the total for the following columns is... Total 2024 OB - 13,27,137 Total 2023 RF9 -14,39,790 Total 2023 RF6 - 14,55,355 TOTAL RF3 2023 -14,14,013 OB23 Total 2023 - 11,97,633 After above columns unpivoted only selected in power query i see large value instead of orginal values but before unpivot its showing correcet value . Also attached power bi sample with before Pivot and after pivot sheet added with same input source. please find the Link Power bi Sample + Input File Looking for support .. thanks in advane..
Measure to Calculate Percentage
Hi Team, Good day, all, I am trying to calculate a percentage of data using a measure in the matrix table format. Vendor Name the Row, In the values, I have M category and M %(this is the field I am trying to work) While I am trying this in the matrix table option in the report, I couldn't able to bring the M category total value divided by the particular M Category. Because the same M category is used in the column, the total value is categorized in the M % calculation. It is stopping me from pursuing further. Any ideas are highly appreciated, thanks. Thanks ShaGuna
Calculate the difference between two hour columns after below conditions have been met
I want to calculate the hours difference between Total Hours and orginal work hours which has date slicer . Dax Query should be written as below and after this conditions have been met then have to calculate the difference between orginal workhours and Total hours WHERE PROJ.Active = 1 AND TAR.ApprovalStatusID IN (5,7,8) (TAE.OriginalWorkHours,0) != TAE.Total Hours TAE.OriginalWorkHours is not null TAR.ApprovalDateTime>DATEADD(s, -1, DATEADD(m, DATEDIFF(m, 0, @pendwkdate)+1, 0)) then difference between orginalworkhours-Totalhours I am trying to write the conditions in Dax but its saying its incorrect = var = maxx(FILTER('ATAS REPORT','ATAS REPORT'[OriginalWorkHours] <> 'ATAS REPORT'[Total Hours] = 'ATAS REPORT'[Total Hours] return MAXX(FILTER('ATAS REPORT','ATAS REPORT'[OriginalWorkHours] <> NULL() )
Create bucketing column based on month_year column
Hi, I have month-year column(jan-2023) in a table.we need to create a two columns one is column1 and column2. Month_Year Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 Jan-25 Feb-25 Mar-25 Apr-25 May-25 Column1 one we need to generate the seires as shown below: Current month starts with series from 0 and so on….,if the current month is may should show it as 0 next month as 1…………. Expected1: Column2: We need to create a second column (Column2) as bucketing based on column1 we neeed to do bucketing 0-1,2-5,6-11,12-23,24+ Expected output: Thanks, SBC
How do I create a % formula between fields
Hi All, I have a data format like this Account Group Amount Acc1 Group1 200 Acc2 Group1 400 Acc3 Group1 100 Acc4 Group1 300 Acc1 Group2 150 Acc2 Group2 600 Acc3 Group2 200 Acc4 Group2 200 I want to calculate the share between accounts in the image below For Acc1 there is no need to do the calculation, for Acc2, Acc3... the calculation is always from Acc1. The calculation is like in the picture column % Help me for cases like thisTime Period with stipulations
I am currently stuck, and I do not know how to even start to write a formula. I have a table that is like a tree. I have one day with three different times, which has a department for each time, which then has a shift for each time. Kind of like this, Department Date/Time Shift Data Fork Lift 1/19/2023 15:01 1st Shift … 2nd Shift … 3rd Shift … 1/19/2023 7:03 1st Shift … 2nd Shift() … 3rd Shift … 1/18/2023 23:01 1st Shift() … 2nd Shift() … 3rd Shift … 1/18/2023 15:01 1st Shift … 2nd Shift … 3rd Shift() … Press 1/19/2023 15:01 1st Shift … 2nd Shift … 3rd Shift … 1/19/2023 7:03 1st Shift … 2nd Shift() … 3rd Shift … 1/18/2023 23:01 1st Shift() … 2nd Shift() … 3rd Shift … 1/18/2023 15:01 1st Shift … 2nd Shift … 3rd Shift() … Data … … … I receive a report every 8 hours, 30 minutes after the previous shift. I will only have up to four dates/times because power query removes everything but my four newest reports. I need to show the three previous shifts for each department. However, the main problem is in the time the report is pulled. Because the information pulls 30 minutes after each shift, it shows incomplete data from the current shift the report was pulled. The report time cannot change because the supervisors need time to fix any problems. Also, the report only pulls by "today" (0:00 - 24:59), not the past 24 hours. I need power bi to figure out the current shift and pull the data from a previous report. I have put a few cells in bold, and a few have parentheses at the end to try to clarify what I need. Every cell with parentheses will need to be used to pull data for the report's current shift. Every shift in bold is the current shift the report has pulled that need to use data from the previous shift. Maybe I am just complicating things, but I cannot figure out how to make power bi do this for me. Can anyone help?Showing logged in user Date time with Type of timezone it belongs to
Hi, In the Report, i need to show the logged in users current Datetime and type of timezone it is showing. Using DAX Now() i will get the current date and time however i am not getting whether it is EST,PST or CET timezone. I need to add timezone also to the timestamp. Please suggest if anything related to Power Query or DAX function this can be achieved. Thanks in Advance.
