Quick question on Prior Year YTD. I've been following the solved solutions on the prior threads but can't get my results to work.
I've created a separate contiguous date table (New Dates) to link to my General Ledger table "Date" column (The GL transactions table has multiple transactions for various dates) as one to many relationship.
I've then written my YTD and prior YTD measures as such:
Net Amount = sum(GeneralLedger[Net Amount])
YTD Total = TOTALYTD([Net Amount],GeneralLedger[Date])