topic Re: Value has been changed After unpivot the columns in power Query in DAX Commands and Tips

Value has been changed After unpivot the columns in power Query

Anonymous — Fri, 16 Feb 2024 08:50:07 GMT

"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..

Re: Value has been changed After unpivot the columns in power Query

bol — Fri, 16 Feb 2024 09:43:05 GMT

Hello,

Here is a formula to calculate one of the sum you are looking for:

Sum of Total 2024 OB = CALCULATE(SUM('Source-Reduced - after unpivot'[Value]),FILTER('Source-Reduced - after unpivot','Source-Reduced - after unpivot'[Attribute]="Total 2024 OB - Copy"))

As all your columns are now rows, you need to filter your calculation of each specific row. In this example, I filter each row (previously column) Total 2024 OB - Copy.

I didn't go very far in the verification because your example is a bit complex (no unique key specified to do a comparison).

Hope this helps.

Re: Value has been changed After unpivot the columns in power Query

Anonymous — Fri, 16 Feb 2024 10:21:05 GMT

bol i want 5 columns unpivot afther unpivot there will be only two columns one fore attribute and another for value .. so i want this 5 columns header want to use slicer in my report.

Re: Value has been changed After unpivot the columns in power Query

bol — Fri, 16 Feb 2024 10:56:20 GMT

This is another question. I answered the first as "how to calculate the same amount".

As far as I understand, you have to create a measure for each of those 5 attributes for all your calculation.
Those 5 measures can be used as "columns" in a table visual (or other visuals).

You can also create a new table with your unique ID and adding those DAX formulas as new columns. That would give you 5 column headers.

As of using slicer, you have to be more specific as I don't get it.

Re: Value has been changed After unpivot the columns in power Query

bol — Mon, 19 Feb 2024 08:35:12 GMT

Anonymous did you succeed?