Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX query

I need help with DAX. So I have tow tables namely Batch and Sentiment. As you can see Batch Table has a company name and one comapny can have multiple assets. Similary in Sentiment table, on...
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    You basically just need to create a realetionship based on asset column, but I will pm you anyway

  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Anonymous my pleasure.
    Make sure that all of the assets are in both tables otherwise you will lose information as in m:m cardinality the blank row concept is not applicable.

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

Anonymous can you share the pbix and I will return one with solution

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hey SpartaBI , I might not be able to share the PBIX. The above data is just the dummy data for reference. I was looking for help in aggregating the sentiments for each company.
Can you please see if you can help here

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    You basically just need to create a realetionship based on asset column, but I will pm you anyway

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank You very much, It comes as a many to many relationship but seems that is the easy way to get this done.
      Thanks again

      • SpartaBI's avatar
        SpartaBI
        Community Champion
        4 years ago

        Anonymous my pleasure.
        Make sure that all of the assets are in both tables otherwise you will lose information as in m:m cardinality the blank row concept is not applicable.