I am stumped with what seems to be a simple formula. I need to create a measure that calculates the YTD totals for each row. This is what I have:
TOTALYTD ( sum ( Fact[Amount] ) , 'Date'[Date] , ALL ('Date'))
'Date'[Date] is the table where I store all possible dates and months.
The problem...