Forum Discussion

vaso's avatar
vaso
Frequent Visitor
2 years ago
Solved

TOTALSALESTODATE

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's avatar
    Anonymous
    2 years ago

    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.

     

     

     

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    vaso 

    Try this pattern:

    Sales To Date = CALCULATE( [Sales Amount] , DATESYTD( 'Date'[Date] ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.