Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
110
Views
Topic starter
Data from ERP has a Date Column (continuous rows by date...1/1/2021, 1/2/2021....); it also has an Accounting Period Column (MonthYear...Jan 2021, Feb 2021...). Part of the cleaning process includes a GroupBy by the Accounting Period (this is done in Power Query)column. Is there an easy way to calculate a YTD column or measure in Power Pivot. Thank you.
Posted : 19/07/2022 4:12 pm
Hi Angel,
Welcome to the forum!
Please see the lessons in session 10 on using the Time Intelligence functions. If you get stuck, please come back to the forum with your question, DAX formula attempt and ideally, a small sample Excel file that illustrates the issue.
Mynda
Posted : 19/07/2022 7:19 pm
