Forum Discussion

Shpongle's avatar
Shpongle
Icon for Helper III rankHelper III
6 years ago

NOOB Q! How to transform data across relationships

Hi gang, My first post, and definitely not my last! I'll be working on a project for the next month or two and will have no shortage of head scratchers, I'm sure!   I've built some interesting stuf...
Need Help
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

Great Shpongle . Glad I could help.

 

It is very common for me to merge tables in Power QUery just for filtering, then remove those filtered columns before bring it into the DAX model. You have any further questions, post back and we'll see how we can help!

Shpongle's avatar
Shpongle
Icon for Helper III rankHelper III
6 years ago

Yeah, I was able to figure it out! It's really easy to do once you know how to do it - I did end up going through those beginner tutorials and it was quickly evident. Being able to expand a table column (where a field contains table data) and choose the specific field I wanted made quick work - I would select the field I wanted and then filter on that column: Boom!

 

I'm pretty sure that I will be merging tables pretty regularly. I really enjoy working with PowerBI - it's such a remarkable tool.

 

Thanks again