Forum Discussion

Salvador's avatar
Salvador
Responsive Resident
9 years ago
Solved

Create a chart using two different dates for the same rows

Hello,   I'm finding some difficulties when trying to create a report from data from our CRM.   I have a table "Invoices", with the information I need to create the chart I want.   My problem i...
Need Help
  • Datatouille's avatar
    Datatouille
    9 years ago

    Hi Salvador

     

    Your issue is classic since you can only have a single active relationship between two tables.

    But you can actually create multiple relationships (only one will be active) and leverage UseRelationship DAX function to locally activate a relationship between two tables.

     

    Checkout this article from MattAllington illustrating UseRelationship.

     

    If you still need some help, ping us :)

Datatouille's avatar
Datatouille
Solution Sage
9 years ago

Hi Salvador

 

Your issue is classic since you can only have a single active relationship between two tables.

But you can actually create multiple relationships (only one will be active) and leverage UseRelationship DAX function to locally activate a relationship between two tables.

 

Checkout this article from MattAllington illustrating UseRelationship.

 

If you still need some help, ping us :)

Salvador's avatar
Salvador
Responsive Resident
9 years ago

TYVM for the sollution, had some issues when linking the dates, because of the datetime fields (our crm gives the exact timestamp), so wasnt linking properly the dates, used format ( field;"YYYYMMDD") to be able to link it :D

 

Working perfectly now