Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Sum up previous data

Hi all

 

So i want to create a line chart, axis are dates, value is the achievement process of sales goal.

Lets say on dez 31 2019 the achievement was 100%, but when inserted in a line chart it shows the daily achivement, so everyday has about the same line height.

What i want instead is summing up the values from previous dates, so dez 31 has the whole 100% and you can see the trend.

 

1.PNG2.PNG

 

Thanks and regards

 

1 ACCEPTED SOLUTION
FrankAT
Community Champion
Community Champion

Hi @Anonymous 

see figure:

11-03-_2020_17-41-43.png

 

Regards Frank AT

 

View solution in original post

3 REPLIES 3
FrankAT
Community Champion
Community Champion

Hi @Anonymous 

see figure:

11-03-_2020_17-41-43.png

 

Regards Frank AT

 

amitchandak
Super User
Super User

Try like

last Day= CALCULATE(SUM(Sales[Sales Amount]),(dateadd('Date'[Date],-1,DAY)))

 

Anonymous
Not applicable

Thanks for the quick response @amitchandak 

Didnt work for me, gives me the same result as just adding the measure by itself.

 

I think i forgot to mention the achivement goal is a measure, so i cant sum it..

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.