Measures work for Calendar Year but not Academic Year

[v-shex-msft]

HI @akbar,

Actually, time intelligence function not works properly on on unfinished date range. It only calculate with existed part instead full range.

For this scenario, I think you had to manually calculate the correspond ranges as filter conditions.(date function)

PYT =
VAR seleted =
    ALLSELECTED ( 'calendar' )
VAR _start =
    MINX ( ALLSELECTED ( 'calendar' ), [date] )
VAR _end =
    MAXX ( ALLSELECTED ( 'calendar' ), [date] )
RETURN
    CALCULATE (
        SUM ( table[amount] ),
        FILTER (
            ALL ( 'calendar' ),
            [date]
                >= DATE ( YEAR ( _start ) - 1, MONTH ( _start ), DAY ( _start ) )
                && [date]
                    <= DATE ( YEAR ( _end ) - 1, MONTH ( _end ), DAY ( _end ) )
        )
    )

Regards,

Xiaoxin Sheng

[akbar]

Hi @v-shex-msft 

Thanks for all your time and help. it seems enough time has passed that the measures can now pick up the neccessary dates and it appears to be fully functional, I appreciate all the help.

Thanks,

Akbar