@unpivot
1 TopicValue 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..1.7KViews0likes4Comments