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
Emmeli
Frequent Visitor

How can I create a montly comulatived graph

Hi. I would appreciate some help with a BI problem of mine.

 

I would like to create a Graph like this

 

Emmeli_0-1685447294460.png

I have one table with budget values

Cost centerAccontMonthBudget
11220 Logistic36900 services soldJan778
11222 Logistic62100 Rent IT-applJan85
11223 Logistic64500 Office appliancesJan-404
11220 Logistic36900 services soldFeb778
11223 Logistic62101 Rent IT-applFeb85
11224 Logistic64501 Office appliancesFeb-404
11220 Logistic36900 services soldMar778
11224 Logistic62102 Rent IT-applMar85
11225 Logistic64502 Office appliancesMar-404
11220 Logistic36900 services soldApr778
11225 Logistic62103 Rent IT-applApr85
11226 Logistic64503 Office appliancesApr-414
11220 Logistic36900 services soldMay778
11226 Logistic62104 Rent IT-applMay85
11227 Logistic64504 Office appliancesMay-414
11220 Logistic36900 services soldJun500
11227 Logistic62105 Rent IT-applJun85
11228 Logistic64505 Office appliancesJun-414
11220 Logistic36900 services soldJul500
11228 Logistic62106 Rent IT-applJul85
11229 Logistic64506 Office appliancesJul-414
11220 Logistic36900 services soldAug778
11229 Logistic62107 Rent IT-applAug85
11230 Logistic64507 Office appliancesAug-414
11220 Logistic36900 services soldSep778
11230 Logistic62108 Rent IT-applSep85
11231 Logistic64508 Office appliancesSep-414
11220 Logistic36900 services soldOct778
11231 Logistic62109 Rent IT-applOct85
11232 Logistic64509 Office appliancesOct-414
11220 Logistic36900 services soldNov778
11232 Logistic62110 Rent IT-applNov85
11233 Logistic64510 Office appliancesNov-414
11220 Logistic36900 services soldDec778
11233 Logistic62111 Rent IT-applDec85
11234 Logistic64511 Office appliancesDec-414

 

And another table with results values

Cost centerAccontMonthResult
11220 Logistic36910 services soldJan397
11200 Logistic62100 RentJan500
11223 Logistic64500 Office appliancesJan-200
11220 Logistic36900 services soldFeb900
11223 Logistic62101 Rent IT-applFeb76
11224 Logistic64501 Office appliancesFeb-404
11220 Logistic36900 services soldMar300
11224 Logistic62102 Rent IT-applMar20
11225 Logistic64502 Office appliancesMar-300
11220 Logistic35200 services soldApr600
11225 Logistic62103 Rent IT-applApr10
11226 Logistic64503 Office appliancesApr-500
11220 Logistic36900 services soldMay400
11226 Logistic62104 Rent IT-applMay50
11227 Logistic64504 Office appliancesMay-800
11220 Logistic36900 services soldJun600
11227 Logistic62105 Rent IT-applJun78
11228 Logistic64505 Office appliancesJun-100
11220 Logistic36900 services soldJul345
11228 Logistic62106 Rent IT-applJul97
11229 Logistic64506 Office appliancesJul-200
11220 Logistic36910 services soldAug778
11229 Logistic62107 Rent IT-applAug85
11230 Logistic64507 Office appliancesAug-414
11220 Logistic36900 services soldSep232
11230 Logistic62108 Rent IT-applSep43
11231 Logistic64508 Office appliancesSep-400
11220 Logistic36900 services soldOct434
11231 Logistic62109 Rent IT-applOct24
11232 Logistic64509 Office appliancesOct-500
11220 Logistic36900 services soldNov900
11232 Logistic62110 Rent IT-applNov67
11233 Logistic64510 Office appliancesNov-300
11220 Logistic36900 services soldDec879
11233 Logistic62110 Rent ITDec8
11234 Logistic64512  appliancesDec-398

 

I would like them to cumulate the values like this and I would like to be able to create the graph shown at the top.

Cumulated ValueBudgetResult
Jan459697
Feb9181269
Mar13771289
Apr18261399
May22751049
Jun24461627
Jul26171869
Aug30662318
Sep35152193
Oct39642151
Nov44132818
Dec48623307

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Emmeli 
Please refer to attached sample file with the proposed solution

2.png1.png

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @Emmeli 
Please refer to attached sample file with the proposed solution

2.png1.png

It worked. Thank you 🙂

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.

Top Solution Authors