Hi DNA team, I’m looking for a help with my Budgets vs Targets Model. SCF FIN1.pbix (324.1 KB) I would like to compare Sales vs Targets Cumulatively on one line graph. The model houses 4 tables: SCF 3 - Sales and SCF 3 Targets ( These Sales run from May 2015 - 2019 ) SCF 4 - Sales and SCF…

Hi @adam I have come up with below solution, please check if it is helpful for you. Made changes to your Data Model. My advice is to always make 1 to Many Relationship b/w Date Table and Fact table to get best results. Modified Cumulative Sales Column as below. This will only return Cumulativ…

Cumulative Totals - To Specific Date Actuals vs Targets

DAX DAX Calculations

EnterpriseDNA February 4, 2021, 1:10am 2

Hello @adam. We have also have threads with some recommendations from other Power BI users which could help. Below are the links where you can view them. Hope this helps.