Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

YTD calculation for non-consecutive years

Good afternoon I would need your help related to a YTD calculation. I have a table called: COMPLETE D_PEDIDO where the fields are: -ENTRY ORDERS EUROS -CREATION DATE and another table M_CA...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Syndicate_Admin ,

 

I suggest you to try code as below to create a measure.

Measure = 
VAR _TODAY =
    TODAY ()
RETURN
    CALCULATE (
        SUM ( 'COMPLETE D_PEDIDO'[ENTRY ORDERS EUROS] ),
        FILTER (
            M_CALENDARIO,
            M_CALENDARIO[Year]
                IN { YEAR ( _TODAY ), 2019 }
                    && M_CALENDARIO[Month] <= MONTH ( _TODAY )
        )
    )

Result is as below.

Best Regards,
Rico Zhou

 

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

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Thank you very much for the help!.

With this solution I have the entry of orders month by month, but what I needed was the accumulated calculation, could you modify the measure to obtain the same calculation but accumulated?

Thank you