Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a report I am working on where I cannot get my dates to play nice with one another. The issue has to do with owner invoices and payments. My model has the customer payments PK linked to the owner invoice table. The owner invoice table is linked to my calendar table. I am unable to create an active relationship between the payment date and my calendar table. The result is that while my invoice amounts are correct, the payment amounts are not. If you look at Page 1, you will see the correct payment amounts for CompanyCode 002. I have a vague recollection that a bridge table might be the answer, but I'm not sure. Any help would be greatly appreciated.
Solved! Go to Solution.
Hi @tlenzmeier,
If i'm understanding your question correctly you want to have the calculation of payments based on calendar table, but you already have a date relationship between both tables.
Make an inactive relationship between the tables Calendar and Owner Payments (assuming this is were you have the payment information) then just change your payment measure to:
Payment Amount = CALCULATE ( SUM ( 'Owner Payments'[PaymentAmount] ); LEFT ( 'Owner Payments'[Transaction Code]; 1 ) = "P"; USERELATIONSHIP ( 'Calendar'[Date]; 'Owner Payments'[Payment Date] ) )
The last part is activating the relationship you created and making the calculations based on context final result below:
Attach PBIX file.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @tlenzmeier,
If i'm understanding your question correctly you want to have the calculation of payments based on calendar table, but you already have a date relationship between both tables.
Make an inactive relationship between the tables Calendar and Owner Payments (assuming this is were you have the payment information) then just change your payment measure to:
Payment Amount = CALCULATE ( SUM ( 'Owner Payments'[PaymentAmount] ); LEFT ( 'Owner Payments'[Transaction Code]; 1 ) = "P"; USERELATIONSHIP ( 'Calendar'[Date]; 'Owner Payments'[Payment Date] ) )
The last part is activating the relationship you created and making the calculations based on context final result below:
Attach PBIX file.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsSo simple! Thank you!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |