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, SBCPower Query from cloud based server and on premise server and union both table together by function
I am in Power Query and I am given a custom function: to query from TWO different SQL servers - before they are different SQL servers but both on premise and right now I need change one server to Cloud version. After change, I was thrown this error message: DataSource.Error: Microsoft SQL: Could not find server 'AAASQL' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. Details: DataSourceKind=SQL DataSourcePath=BBBSQL;CSA Message=Could not find server 'AAASQL' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. ErrorCode=-2146232060 Number=7202 Class=11
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 this
