topic TOTALSALESTODATE in DAX Commands and Tips

TOTALSALESTODATE

vaso — Sun, 14 Jan 2024 20:29:52 GMT

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.

Re: TOTALSALESTODATE

Fowmy — Sun, 14 Jan 2024 20:43:51 GMT

vaso

Try this pattern:

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

Re: TOTALSALESTODATE

Anonymous — Tue, 16 Jan 2024 09:53:26 GMT

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.