Forum Discussion
Solved
Diferent values with the same filter
HI guys i need help with a table that have 2 different dates is look like this and the sell amount is with the filter form the column redem date, and beside of that i need calculate the se...
Give these two measures a try:
less sell =
VAR FromDate = MIN( 'Calendar'[Date] )
VAR ToDate = MAX( 'Calendar'[Date] )
VAR Result =
CALCULATE(
SUM( 'Table'[sell] ),
FILTER(
'Table',
'Table'[buy date] < FromDate
&& 'Table'[redem date] >= FromDate
&& 'Table'[redem date] <= ToDate
)
)
RETURN
Result
and:
future sell =
VAR FromDate = MIN( 'Calendar'[Date] )
VAR ToDate = MAX( 'Calendar'[Date] )
VAR Result =
CALCULATE(
SUM( 'Table'[sell] ),
FILTER(
'Table',
'Table'[buy date] >= FromDate && 'Table'[buy date] <= ToDate
&& 'Table'[redem date] > ToDate
)
)
RETURN
Result
-Steve
HI Steve SteveHailey thanks for the answer, i did both measure but the result is blank, i change some part off the measure but the same result...., you have any other idea, i will appreciate.
thanks and reagrds