cumulative totals from previous days and monthly

[Syndicate_Admin]

Good, my first post and I hope you can help me get out of this dilemma, I need to pass the following image to a dynamic table in powerbi of a bdd, what is complicated for me is to work the accumulated dates I have the gross sale data and goal from the current day to last year, the first row is accumulated from the current month, the last days respectively, but I can not do it, any help would be useful to me, and I attach as is my calendar table.

[VijayP]

@Syndicate_Admin 

if you can add some sample data it will helpful to derive solution

[Syndicate_Admin]

This is my Main base where I have gross vta and goal that are the ones that I have to accumulate in the ranges of days that I show above, the main problem for example is the sum of gross vta according to the days.

[v-easonf-msft · Accepted solution]

Hi, @Syndicate_Admin 

You need to create dynamic columns "Start Date","End Date" first.
Table:

So that you can use measure as below to calulate the cumulative totals:

cumulative totals_vta_bruto =
CALCULATE (
    SUM ( 'Fact table'[Vta_Bruto] ),
    FILTER (
        'Fact table',
        'Fact table'[Fecha] >= SELECTEDVALUE ( 'Table'[Start Date] )
            && 'Fact table'[Fecha] <= SELECTEDVALUE ( 'Table'[End Date] )
    )
)

cumulative totals_Meta =
CALCULATE (
    SUM ( 'Fact table'[Meta] ),
    FILTER (
        'Fact table',
        'Fact table'[Fecha] >= SELECTEDVALUE ( 'Table'[Start Date] )
            && 'Fact table'[Fecha] <= SELECTEDVALUE ( 'Table'[End Date] )
    )
)

Best Regards,
Community Support Team _ Eason