Sum all reservations quantity whenever the reservation month <= PR release month.

[Moha_shanti]

Hi,

I have a 2 tables one contain reservation list aginst materials and another have PRs requests aginst materials as well.

I made the relation between both based on Material number becuase it is the only Key in both tables.

I have in reservation table approval dates and in other table [PR list table] PR release month.

I want to sum all reservations quantity whenever the reservation month <= PR release month.

Please lokk to below exsmple for more clearification

[Mahesh0016]

Hello @Moha_shanti 

reservations quantity =

CALCULATE (

    SUM ( 'Table AB'[PR Number] ),

         ALLEXCEPT('Table','Table'[PR release month])  

)

@Moha_shanti I hope this helps you!Thank You!!

[Moha_shanti]

No that will sum the PR number, the rrequired is to sum the reservation quantity henever the reservation month <= PR release month.