Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Summing Sales between two different date fields

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...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , 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]) ) )

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , 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]) ) )