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.

     

     

     

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.