Listwise multiplication in power query query

As usual when you transition from Excel to Power BI, the first thing you need to do is unpivot your data to bring it into a usable format.  After that you can decide if you even want to do the calculations in Power Query, or if it is simpler and faster to do them in Power BI.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WUjDUMzBQUNIBMyyhDEMLKMPYDMowgUlZmEMZlhARIz0jE5h2g4FmxMYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"2024/9" = _t, #"2024/6" = _t, #"2024/3" = _t, #"2023/12" = _t, #"2023/9" = _t, #"2023/6" = _t, #"2023/3" = _t, #"2022/12" = _t, #"2022/9" = _t, #"2022/6" = _t, #"2022/3" = _t, #"2021/12" = _t, #"2021/9" = _t, #"2021/6" = _t, #"2021/3" = _t, #"2020/12" = _t, #"2020/9" = _t, #"2020/6" = _t, #"2020/3" = _t, #"2019/12" = _t, #"2019/9" = _t, #"2019/6" = _t, #"2019/3" = _t]),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {}, "Month", "Value"),
    #"Changed Type" = Table.TransformColumnTypes(#"Unpivoted Columns",{{"Value", type number}})
in
    #"Changed Type"

hi

Thank you for your answer.

I don't use Power BI.

Taking it out of the pivot table and reintroducing it into the process would cause me to do a lot of extra work, like a vicious cycle.

It would be better to do this during the power query before the pivot table result.

I think this is what your code does
"
Source = Excel.CurrentWorkbook(){[Name="inflation"]}[Content],
#"PivotColumnsResolved" = Table.UnpivotOtherColumns(Source, {}, "Property", "Value"),
"

But the next thing I need help with is:
It is the multiplication of the inflation coefficient under the period by all values ​​corresponding to the same period.

let
rate = Excel.CurrentWorkbook(){[Name="inflation"]}[Content],

    // Sembollerin alınması ve filtrelenmesi
    tblSymbols = Excel.CurrentWorkbook(){[Name="tblSymbols_Sector"]}[Content],
    RenamedColumns = Table.RenameColumns(tblSymbols, {{"Column1", "Symbol"}}),
    FilteredSymbols = Table.SelectRows(RenamedColumns, each [Symbol] <> null),
    // Sütun türlerinin değiştirilmesi
    ChangedType = Table.TransformColumnTypes(FilteredSymbols, {{"Symbol", type text}}),
    // Taban URL'lerin eklenmesi ve genişletilmesi
    BaseURLs = Excel.CurrentWorkbook(){[Name="tblFinansal_URLs"]}[Content],
    GetBaseURL = Table.AddColumn(ChangedType, "BasedURL", each BaseURLs),
    ExpandedBasedURL = Table.ExpandTableColumn(GetBaseURL, "BasedURL", {"URL"}, {"URL"}),
    // Sembollerin URL'ye eklenmesi ve verilerin alınması
    ReplacedSymbol = Table.AddColumn(ExpandedBasedURL, "ReplaceSYMBOL", each Text.Replace([URL], "SYMBOL", [Symbol])),
    GetSourceValue = Table.AddColumn(ReplacedSymbol, "GetData", each Table.FromList(Json.Document(Web.Contents([ReplaceSYMBOL]))[value], Splitter.SplitByNothing(), null, null, ExtraValues.Error)),
    // Verilerin genişletilmesi
    ExpandedGetData = Table.ExpandTableColumn(GetSourceValue, "GetData", {"Column1"}, {"Column1"}),
    ExpandedColumn = Table.ExpandRecordColumn(ExpandedGetData, "Column1", {"itemCode", "itemDescTr", "itemDescEng", "value1", "value2", "value3", "value4"}, {"itemCode", "itemDescTr", "itemDescEng", "value1", "value2", "value3", "value4"}),
    // Seçilen sütunların unpivot edilmesi
    UnpivotedColumns = Table.Unpivot(ExpandedColumn, {"value1", "value2", "value3", "value4"}, "ValueNo", "Value"),
    // URL'den dönem bilgisi alınması
    GetPdFromURL = Table.AddColumn(UnpivotedColumns, "GetPeriodFromURL", each Text.AfterDelimiter([URL], "&year"), type text),
    SplitColumn = Table.SplitColumn(GetPdFromURL, "GetPeriodFromURL", Splitter.SplitTextByDelimiter("&year", QuoteStyle.None)),
    // Dönem sütunlarının unpivot edilmesi
    UnpivotedPeriodColumns = Table.Unpivot(SplitColumn, List.Select(Table.ColumnNames(SplitColumn), each Text.StartsWith(_, "GetPeriodFromURL.")), "Attribute", "TempPd"),
    // Dönem bilgisine göre özel sütun eklenmesi
    AddedCustom = Table.AddColumn(UnpivotedPeriodColumns, "Period", each if Text.End([ValueNo], 1) = Text.Start([TempPd], 1) then Text.Replace(Text.End(Text.Start([TempPd], Text.PositionOfAny([TempPd], {"&"}, Occurrence.First)), 4) & "/" & Text.End([TempPd], Text.Length([TempPd]) - Text.PositionOfAny([TempPd], {"="}, Occurrence.Last) - 1), "&", "") else null),
    // Null değerlerin filtrelenmesi
    FilteredRows = Table.SelectRows(AddedCustom, each ([Period] <> null) and ([TempPd] <> "")),
    // Gereksiz sütunların kaldırılması
    RemovedColumns = Table.RemoveColumns(FilteredRows, {"URL", "ReplaceSYMBOL", "ValueNo", "Attribute", "TempPd"}),
    // Sütun türlerinin yeniden değiştirilmesi
    ChangedTypeFinal = Table.TransformColumnTypes(RemovedColumns, {{"Value", Int64.Type}}),
    // Pivot işlemi
    PivotedColumn = Table.Pivot(ChangedTypeFinal, List.Distinct(ChangedTypeFinal[Period]), "Period", "Value")
in
    PivotedColumn

DNZ.xlsx

hi

I couldn't understand how this had anything to do with what I wanted.
I don't use "power bi".
Can this operation be done in "power query"? If so, how.
The sample excel file is there.
Thank you.

The action I want is
It was more complex than that and was in interrogation.
However, I realized that the transaction I wanted could not be solved this way.
Thank you for your answer and efforts.