Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Counting through multiple tables

Hello,    I am managing data from a client database with Clients, Projects, and project interactions.    I have re-created this within Power BI and am now trying to calculate a few things. One of...
Need Help
tex628's avatar
tex628
Community Champion
6 years ago

Would it be possible for you to take a picture of the relationship pane in PBI? I'm having issues getting a clear picture of the structure.

/J

Anonymous's avatar
Anonymous
Not applicable
6 years ago
 

Yes - Sorry, didn't realise that I needed to sign in in order to do this...

 

Thanks 

 

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Would you please show us some sample data. Please erase unnecessary data and sensitive data, we only need a part for testing.

     

    Best Regards,

    Dedmon Dai

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for your replies. I removed the bridge table 'distinct client record id' from the model. So please ignore that in the above screen shot. Here is some mock data: I'm trying to count distinct clients that have had a project interaction since X date. So in the example below. If I select dates as between 01/03/20 ad 01/05/20. then the result will be two clients - John and Mary. Ideally, the solution would allow me to alter the dates and see how many clients in that time easily. I don't know if i need to create an independent dates table for that also? Thanks 

       

      See below comment for sample data 

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        The data you gave us is unreadable.

         

        Best Regards,

        Dedmon Dai