Matrix Help- Cash Basis Analysis

[CK1]

Hey,

I am hoping someone may have run into this scenario and knows of a relatively easy way to solve this. I work in the healthcare industry and I am trying to put together an analysis to see what amount of payments were received for a specific service date period. For example, if I provided $50k in services in January, but the payments for those services didn't come in until March I want to know how much I received relating to Jan services. Here is a quick grid example: 

Is there an easy (ish) way I can set this up in power BI?

Thank you!

[CK1]

Yes, I do have a date table set up, here is a snip from the data I'm trying to include in the table. right now I have the service date field linked to the date table in a one-to many relationship. I linked the service date rather than the posted date because that will be the same dates I want to use to organize my charges. 

Data table: 

 

Date Table:

[vanessafvg]

you will need to add another relationship between the 2 tables.  This will be between posted date and date in the date table.   The relationship will be inactive ie dashed.

in order to activate that relationship in your measure ie payments you just point to the inactive date relationship by using the userelationship function.

so it would look something like this (after creating the additional relationship)

payment by service date =
SUM ( table[payments] )

payments by payment date =
CALCULATE (
[payments by service date],
USERELATIONSHIP ( table[postedDate], date[Date] )
)

then when you plot your date from the date table, it will bring back both measures plotted on the same date.   

[vanessafvg]

do you have a date table?  please can you give a sample of what you date looks like and if you have a date table and the relationhships you have between table