I'm struggeling to understand why my TOTALYTD function doesn't work as it should be.
What am I doing wrong?
Go to Solution.
You need to create a Calendar table which contains a date column, build a relationship between Invoice table and Calendar table based on the date column. Then create a measure like below:
InvoiceAmount YTD = TOTALYTD([InvoiceAmount Measure], Calendar[Date])
Best Regards,Qiuyun Yu
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!