Cross Date and Amount from 2 sides

[Anonymous]

Hello everyone,

Sorry, I got one problem...

I m gonna try to be clear... 😉

I got a Table "Reservation" with id

The idReservation is linked with 2 Tables. One of it contains the amounts, the other contains the planning (the dates).

And the Table which contains the Date is linked with my Table "date" obviously.

(You can notice that a reservation may be on several days...si on serveral month)

And I would like my amount for each month.

I think you have all the informations.

Thank you for all,

[v-yuta-msft]

Hi bapt69,

What's the table structure between the two tables? Suppose the relationship between table ’Date‘ and 'Reservation' is one-many, you can create a calculate column using DAX below to achieve amount in each Month:

Amount =
CALCULATE (
    COUNT ( Reservation[id] ),
    FILTER ( Date, MONTH ( Date[date] ) = MONTH ( EARLIER ( Date[Date] ) ) )
)

Regards,

Jimmy Tao

[Anonymous]

Sorry, the dates are on the Table wich is linked at Reservation.

There is no Date on the table Reservation.

Date -> Ressources (with planning) <- Reservations -> Inscriptions -> InsciptionLines (with amounts)

(All links one-many)