Forum Discussion

ricod's avatar
ricod
Icon for Helper I rankHelper 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
ricod's avatar
ricod
Icon for Helper I rankHelper I
1 year ago

the april result is not correct, should be 2

 

 

 

anilelmastasi's avatar
anilelmastasi
Icon for Super User rankSuper User
1 year ago

Could you write this formula?

Variation = 
VAR CurrentMonth = MAX(DateTable[Date])
RETURN
SUMX(
    FILTER(
        ALL(DateTable),
        DateTable[Date] <= CurrentMonth
    ),
    [IN] - [OUT]
)