Summing Sales between two different date fields

[M_BODNER]

I have sales in Invoice Line Items table with an invoice date and I need to sum those sales between two dates - the Check In and Check Out dates in the Hotel Reservation table. So essentially summing sales when the invoice date is on or between the check in and check out dates.

[M_BODNER]

Thank you!!! Your second suggestion worked like a charm.

[amitchandak · Accepted solution]

@M_BODNER , A new column  Reservation 

sumx(filter(Invoice, Invoice[Date]>= Reservation[Check in] && Invoice[Date]<= Reservation[Check out]), Invoice[Value])

or

Try a measure like

Sumx(Reservation,

sumx(filter(Invoice, Invoice[Date]>= Reservation[Check in] && Invoice[Date]<= Reservation[Check out]), Invoice[Value]) )

or

Sumx(Reservation,

calculate( sumx(filter(Invoice, Invoice[Date]>= Reservation[Check in] && Invoice[Date]<= Reservation[Check out]), Invoice[Value]) ) )