I'm trying to get cumulative totals using the following table:
Table Name: PS_SalesHistory
Columns: Sales, Effective Date, Fiscal Year
This calcuation is giving me cumulative total for all dates, but I need to break that up by the Fiscal Year column.
The fiscal year for my company is August 1 to July 31, so it doesn't follow the calendar year.
Go to Solution.
@GTPowerBIUser when working with dates, as a best practice add a calendar/date dimension your model, follow my blog post to add this table Create a basic Date table in your data model for Time Intelligence calculations | PeryTUS IT Solutio...
Create the following measure and use the Year from date dimension table.
DATESYTD ( Calendar[Date], "07/31" )
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Proud to be a Super User! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
View solution in original post
@GTPowerBIUser not sure why, change cross filter to single, and if doesn't work, share the pbix file, remove sensitive information before sharing.
I have a date dimension table, however its not working with that table. When I insert your calculation I get:
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!