Forum Discussion

Dave93's avatar
Dave93
Frequent Visitor
9 years ago
Solved

Handling two different dates on the Axis

Hi,   Could someone help me with the following. I want to show for every month the total amount of invoices compared to the total amount of paid invoices.    To calculate the total amount o...
Need Help
  • Dave93's avatar
    Dave93
    9 years ago

    Never mind, with some trial and error I found the solution. I had to use the USERELEATIONSHIP function.

     

    Measure =
CALCULATE (
    SUM ( 'Payment Behaviour'[PaymentAmount] );
    USERELATIONSHIP ( 'Payment Behaviour'[PaymentDate]; Datum[Datum] )
)

     

Dave93's avatar
Dave93
Frequent Visitor
9 years ago

Never mind, with some trial and error I found the solution. I had to use the USERELEATIONSHIP function.

 

Measure =
CALCULATE (
    SUM ( 'Payment Behaviour'[PaymentAmount] );
    USERELATIONSHIP ( 'Payment Behaviour'[PaymentDate]; Datum[Datum] )
)