Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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])
Nope, I don't have [Transactions.Txn Year] field but i got the point.
Ok thanks a lot