DAX Problem Accum from First Date with Sales to Last Date with Sales

[dpombalpbi]

I have a basic Calendar table joined by date to a Fact table with Sales data.

And I want for each item, a product is selected, to accumulate sales of all dates with Sales

I used this blog but formula doesn't work for me on totals

https://interactivechaos.com/en/dax/scenario/calculation-accumulated-totals

Sales = SUM (FACT_SALES[Sales])

Sales Acum =

VAR __firstDate = FIRSTDATE(ALL(FACT_SALES[Date]))

VAR __lastDate = MAX('CalendarT'[Date])

RETURN

    CALCULATE(

        [Sales],

        DATESBETWEEN(

            'CalendarT'[Date],

            __firstDate,

            __lastDate

        )

    )

For this product Filtered there are Sales from October 2022 to February 2023

And Table with current Measure Sales Accumulated is this.

Formula works OK for months in dates with sales between the first period with Sales from October 2022 to February 2023

But I don't want to show totals before first sale date and after last date with data -.

I want to control to show blank or do nothing first and after

[v-tangjie-msft · Accepted solution]

Hi @dpombalpbi ,

According to your description, here are my steps you can follow as a solution.

(1) We can create a new measure.

new sale acum = IF('Table'[sales]=BLANK(),BLANK(),'Table'[sale acum])

(2) Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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