Forum Discussion

PowerCris's avatar
PowerCris
Regular Visitor
4 years ago
Solved

Tables structure issue

Hi everyone, Cris here, with my very first steps in PowerBI. I'm a self-taught Excel-fan and consider myself at an average level. I got fascinated by PowerBI and want to improve the way I present my...
Need Help
  • PowerCris's avatar
    PowerCris
    4 years ago

    Hello Eyelyn and thanks for getting back to me.

    Yes, I did try to merge the queries but without getting the result I wanted. My idea of knowing "from which tables data were coming from" was becasue the table name was already allowing me to filter the type of data.

    However, I think I solved my problem using the List.Zip function. Solution was not "mine" but I took if from THIS video. With this trick, I don't even have to split the original source data into two tables (market & MyShare).

    It perfectly does what I needed to with little if no effort for data-cleaning...

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi PowerCris ,

 

Not very clear about this:
how the new combined table can pass the info of which unit comes from table1 and which one from table2...

 

Did you try to merge these two tables, or build relationships between them? Refer to:

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Docs

 

Better to provide some details about your tables and your expected output (like data sample,screenshots...)to help us clarify your scenario.

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

How to Get Your Question Answered Quickly - Microsoft Power BI Community

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PowerCris's avatar
PowerCris
Regular Visitor
4 years ago

Hello Eyelyn and thanks for getting back to me.

Yes, I did try to merge the queries but without getting the result I wanted. My idea of knowing "from which tables data were coming from" was becasue the table name was already allowing me to filter the type of data.

However, I think I solved my problem using the List.Zip function. Solution was not "mine" but I took if from THIS video. With this trick, I don't even have to split the original source data into two tables (market & MyShare).

It perfectly does what I needed to with little if no effort for data-cleaning...

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi PowerCris ,

     

    Thanks for your sharing !More people will benefit from it.😀

     

    Best Regards,
    Eyelyn Qin