Forum Discussion

ricod's avatar
ricod
Helper I
1 year ago

Variation IN and OUT

Hello   i've a folder with xslx files containing cat and dog names. i want from 1st september 2024 calculate the variation of placements. i've tried many thinks with date table or not but i'm not a...
Need Help
Fowmy's avatar
Fowmy
Super User
1 year ago

ricod 

Create a dates table and a relationship.

Add these measures:

IN = 

COUNTROWS(
    FILTER(
        Table01,
        Table01[arrival] >= MIN(Dates[Date]) &&
        Table01[arrival] <= MAX(Dates[Date])
    )
)

 

OUT = 

COUNTROWS(
    FILTER(
        Table01,
        Table01[departure] >= MIN(Dates[Date]) &&
        Table01[departure] <= MAX(Dates[Date])
    )
)

 

Variance  = [IN] - [Out]