Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

SQL data of Running Total By Country (WITHOUT DAX)

Hi,   I am totally new to Power BI and DAX. I am comfortable with SQL reporting. My issue is I have imported data from SQL reporting queries to visualise on PowerBI. One of them is creating data o...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi YukiK /forum members,

 

I guess I understood the problem. I was adding values from two different tables without forming any relationship.

They are not directly related. As you can see , in the image. Let me know what kind of relationship needs to be formed based on date or location?

 

 

 

It will be a great help !

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI Anonymous,

    I do not so recommend you to use 'many to many' relationship link table records, they may cause some issues for relationship mapping and records analysis.
    For this scenario, you can refer to the following blog to create a bridge table to link two table records:

    How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

    Regards,

    Xiaoxin Sheng