Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

PowerBI Query - transform, assign and move Data into other fitting cells

Hello Power BI Board, its a little hard to describe my problem, but i have to following challenge infront of me:   I cleaned and transformed a Dataset into the following Dataset: (the last column...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    Anonymous see attached, in PQ I have created a function called fnFillData that takes care of the logic you explained (I understood), you can tweak it as you see fit.

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

parry2k's avatar
parry2k
Super User
4 years ago

Anonymous see attached, in PQ I have created a function called fnFillData that takes care of the logic you explained (I understood), you can tweak it as you see fit.

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thx works like a charm, learned a lot from that:) Thx a lot for your help and great idea:)