Set Analysis Problem

[shakil4sk]

I have created a Previous Year YTD measure

Sum({$<[Transactions.Account Type]={'Expense','Income','Cost of Goods Sold'},
[Transactions.Txn Date] = {">=$(=AddYears(YearStart(Max([Transactions.Txn Date])),-1))<=$(=AddYears(Max([Transactions.Txn Date]),-1))"}>}[Transactions.Amount With Sign])

 when i select year filter it shows 0 but when i select month it shows correct value.

i could not figure out the problem.

Please help

[sunny_talwar · Accepted solution]

What is the your year field called? Assuming it is called [Transactions.Txn Year], try this

Sum({$<[Transactions.Account Type]={'Expense','Income','Cost of Goods Sold'},
[Transactions.Txn Date] = {">=$(=AddYears(YearStart(Max([Transactions.Txn Date])),-1))<=$(=AddYears(Max([Transactions.Txn Date]),-1))"}
, [Transactions.Txn Year]>}[Transactions.Amount With Sign])

[Vegar]

Your year selection is affecting your expression. You need to cancel out year

Sum({$<
Year,
[Transactions.Account Type]={'Expense','Income','Cost of Goods Sold'},
[Transactions.Txn Date] = {">=$(=AddYears(YearStart(Max([Transactions.Txn Date])),-1))<=$(=AddYears(Max([Transactions.Txn Date]),-1))"}
>}[Transactions.Amount With Sign])

[shakil4sk]

Nope, I don't have [Transactions.Txn Year] field but i got the point.

Ok thanks a lot