Forum Discussion

Yaroslav__D's avatar
Yaroslav__D
New Member
1 year ago

Calculate Iterate Levels in M

Hi  ALL!  I tried to calculate in power query levels for my accounts to calculate all of them later . I used this code to do it , but is`s don`t work , maybe someone know what could be wrong?  let...
data engineering
Yaroslav__D's avatar
Yaroslav__D
New Member
1 year ago

Hi , no, this issue not resolved .
yes , sure ,  mappingrules looks literally like this 

TargetAccountSourceAccountOperator
P003099P001010+
P003099P002010+
P003099P002030+
P008999P003099+
P008999P004050+
P013099P013010+
P013099P013020+
P013099P013025+
P013099P013030+
P013099P013035+
P013099P013040+
P013099P013050+
P013099P013062+
P013099P013064+
P013099P013070+
P013099P013080+
P013099P013095+
P014099P014010+


in Balance we have similar list where we find our Source Account , to give level 1 or null

Thanks 

lbendlin's avatar
lbendlin
Super User
1 year ago

consider using Expression.Evaluate

  • v-priyankata's avatar
    v-priyankata
    Community Support
    1 year ago

    Hi Yaroslav__D 

    Thank you for reaching out to the Microsoft Fabric Forum Community. sorry for delay.

    Idea to use Expression.Evaluate is a really good one or Please try the code below. it may helps you. lbendlin Thanks for your inputs. 
    If the issue persists, feel free to reach out to us. We are happy to assist you.

    Table.TransformRows(
    currentTable,
    (row) =>
    if row[Level] <> null then row
    else
    let
    match = Table.SelectRows(DependencyMap, each [TargetAccount] = row[Account]),
    sources = if Table.IsEmpty(match) then {} else match{0}[Sources],
    allResolved = List.IsEmpty(List.Difference(sources, assignedAccounts))
    in
    if allResolved then Record.TransformFields(row, {{"Level", each currentLevel + 1}})
    else row
    )

    • v-priyankata's avatar
      v-priyankata
      Community Support
      1 year ago

      Hi Yaroslav__D 

      I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

      • v-priyankata's avatar
        v-priyankata
        Community Support
        1 year ago

        Hi Yaroslav__D 

        Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted. If yes, marking the solution would be awesome for others who might run into the same thing.