Sum of Revenue upto Selected Date

[MSFTPBI]

Hello,

I have a table Table1, with RevenueDate, and Revenue
I have a slicer in report on RevenueDate. User can select range of dates, but I want to ignore Initial selected date and just provide Revenue upto end date.

Example: First date in table is 01/01/23 and Last Date is 3/20/23
If User Selects

02/02/23  and 3/15/23

I need to show Sum of Revenue Falls between 01/01/23 (ignoring 02/02/23) to 3/15/23

Apprecite your help.

[Greg_Deckler]

@MSFTPBI Try:

Measure =
  VAR __Min = MINX(ALL('Table'), [Date])
  VAR __Max = MAX('Table'[Date])
  VAR __Table = FILTER(ALL('Table'), [Date] >= __Min && [Date] <= __Max)
  VAR __Result = SUMX(__Table, [Revenue])
RETURN
  __Result

[MSFTPBI]

@Greg_Deckler  getting error"The Expreession refers to multiple columns. Multiple columns cannot be convertes to a scalar value.
Here is my DAX

REVDate =

var vMin = MINX(ALL('TABLE1'), 'TABLE1'[Revenue Date])

var vMAX = MAX('Table1'[Revenue Date])

var vTab = Filter(All('Table1'),[Revenue Date]] >= vMin &&  [Revenue Date]]) <=  vMAX

var vResult= SUMX(vTab, 'Table1'[Revenue])

RETURN

vResult

[Greg_Deckler · Accepted solution]

@MSFTPBI Some syntax errors. I think I got all of them, extra ]'s and a missing )

REVDate =
var vMin = MINX(ALL('TABLE1'), 'TABLE1'[Revenue Date])
var vMAX = MAX('Table1'[Revenue Date])
var vTab = FILTER(All('Table1'),[Revenue Date] >= vMin &&  [Revenue Date]) <=  vMAX)
var vResult= SUMX(vTab, 'Table1'[Revenue])
RETURN
vResult

[MSFTPBI]

@Greg_Decklersomehow still not working