Forum Discussion

utkuacik's avatar
utkuacik
Frequent Visitor
3 years ago
Solved

how to copy rows depending on column values

Hi guys, so sorry if this question is asked before , but after searching 3 day in internet , i could not find a solution , probably i am new to power BI and M language.  so sorry if i made aa mistake , cause it is my first time writing to a forum . thank you all

 

i have a table with 13 columns.   i just want to copy rows according to values in columns named "from" and "to" .  

  • In power query, Add Column -> custom column.

    {[From]..[To]}

    then Expand the column (from the header) 'to rows'

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

    In power query, Add Column -> custom column.

    {[From]..[To]}

    then Expand the column (from the header) 'to rows'

    • utkuacik's avatar
      utkuacik
      Frequent Visitor

      you are my hero 🙂 thank you so much