TOTALSALESTODATE

[vaso]

Hi , is there a function that shows the sales u to date . For example , if my sales start at 1/1/2018 and

I select February 2013 I want to see the sales from 1/1/2018 till 28/2/2013. 

[Anonymous · Accepted solution]

Hi @vaso 

@Fowmy Good share!

For your question, here is the method I provided:

Here's some dummy data

"Table"

Create a measure. You can calculate the total number based on the selection of slicers.

Total values = 
    var select_date = 
        IF(
            ISFILTERED('Table'[Date]), 
            VALUES('Table'[Date]), 
            BLANK()
        )
RETURN 
    CALCULATE(
        SUM('Table'[values]), 
        FILTER(
            ALL('Table'), 
            'Table'[Date] <= select_date
        )
    )

Here is the result

Regards,

Nono Chen

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

[Fowmy]

@vaso 

Try this pattern:

Sales To Date = CALCULATE( [Sales Amount] , DATESYTD( 'Date'[Date] ) )