Create a chart using two different dates for the same rows

[Salvador]

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 is that, I need to create a chart that displays the invoiced ammount for each month, that would use the "Invoiced Ammount" and the "Emission Date" fields, and the revenue, that would use the "collected ammount" and the "collection date" fields.

Is there any way that I could sort in the same chart, data from two different fields, using one different date for each?

[Datatouille · Accepted solution]

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]

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 😄

Working perfectly now