Forum Discussion

Gavin_Shales's avatar
Gavin_Shales
Frequent Visitor
8 years ago
Solved

Counting dates from one table to another

Hi,

 

I have two tables, TableA contains a list of running unique dates and I want to connect this to tableB so that I can seperately count how many Complaints were received on that date, and how many were closed. It's very simple but I cannot find an answer to this.

 

Any help would be great.

 

Than you,

Gavin

  • Gavin_Shales's avatar
    Gavin_Shales
    8 years ago

    I managed to figure this out by using Calculate and UseRelationship functions

     

    I had to initally Link the two tables using a primary Link, then create a 2nd link and activate it in the Dax Formula.

     

    Thanks for taking a look,

     

    Regards

    Gavin

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi Gavin_Shales,

     

    On the Manage relationships create the connection between the two table by date, then just add the date in your table and the ID or other field in your complaint table to make the count.

     

     

    Regards,

    MFelix

    • Gavin_Shales's avatar
      Gavin_Shales
      Frequent Visitor
      8 years ago

      Thank you for the reply, MFelix. I can only link the table on either the ReceivedDate or the ClosedDate in my complaints table. I want to be able to come up with a count of how many were Received and how many were Closed on a daily basis. Does your method acheive this?

      • Gavin_Shales's avatar
        Gavin_Shales
        Frequent Visitor
        8 years ago

        I managed to figure this out by using Calculate and UseRelationship functions

         

        I had to initally Link the two tables using a primary Link, then create a 2nd link and activate it in the Dax Formula.

         

        Thanks for taking a look,

         

        Regards

        Gavin