Counter in between two dates && delivery older than 5 years

Jaesonkim — Tue, 25 Apr 2023 07:44:25 GMT

Hello, i want to have your best solution again for the dax calculation

i have 2 simple table as date lookup and contract table.
if i make filter with the date lookup and i choose certain year month, i want to show the contract number, which are in the between the two dates (Contract start ~ Expired date) and product delivery older than 5 years.

https://drive.google.com/file/d/1OGfUmZppS1cLcrbJOJ4M3eOXX9hiT3Tf/view?usp=share_link

Re: Counter in between two dates && delivery older than 5 years

tamerj1 — Tue, 25 Apr 2023 11:54:36 GMT

Hi Jaesonkim
Please refer to attached sample file with the proposed solution

FilterMeasure = COUNTROWS ( FILTER ( 'Table', DATEDIFF ( 'Table'[Product delivery], TODAY ( ), YEAR ) >= 5 && 'Table'[Contract start] <= MAX ( 'Lookup Date'[Date] ) && 'Table'[Expired date] >= MIN ( 'Lookup Date'[Date] ) ) )

topic Re: Counter in between two dates && delivery older than 5 years in DAX Commands and Tips

Counter in between two dates && delivery older than 5 years

Re: Counter in between two dates && delivery older than 5 years