hiding future (or some) date for calculations in dax in a time intelligence function

[Anonymous]

Hello Everyone! 

I’ve got this measure which calculate the Moving Annual Total of ImportoAvere+ (just a simple SUM of Importo). In this case i want to hide the first year so PrimoAnno (aka FirstYear) is “FALSE”.

MATImportoAvere+ = CALCULATE([ImportoAvere+];

                                                        CALCULATETABLE(DATESINPERIOD(Calendario[DataUnica];

                                                                                                                 LASTDATE(Calendario[DataUnica]);

                                                                                                                 -12;

                                                                                                                 MONTH);

                                                                                     Calendario[PrimoAnno]=FALSE()

                                                                                      )

                                                                                 )

As shown below there is a value in the first date (01/01/2008) that is repeated until the end of the year and i don’t know why it’s not hide. CAN SOMEONE HELP ME?

[v-yuta-msft]

@Anonymous ,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao

[v-yuta-msft]

@Anonymous ,

Modify your measure as pattern below and check if this issue persists:

MATImportoAvere+ =
CALCULATE (
    [ImportoAvere+];
    FILTER (
        DATESINPERIOD (
            Calendario[DataUnica];
            LASTDATE ( Calendario[DataUnica] );
            -12;
            MONTH
        );
        Calendario[PrimoAnno] = FALSE ()
    )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.