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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PonyBoy67
Regular Visitor

Transposing summed column values from one table into another table

Background

I have two tables.

Table 1 - called Pipeline - which is raw data extracted from another database showing the forecast revenue of several projects accross a number of months from current month to 12 months in the future.

Opportunity ID#Revenue Month1Revenue Month2Revenue Month3Revenue Month4Revenue Month5Revenue Month6Revenue Month7Revenue Month8Revenue Month9Revenue Month10Revenue Month11Revenue Month12
OPP-120940402514325143251432514325143251432514325143251432514325143
OPP-1216857000000002500250025002500
OPP-976759000330833308333083330833308333083330833308333083
OPP-1029933062686268626862686268626862686268626862686268
OPP-1240588000000000563563563
OPP-1240590000000000000
OPP-1137808000000000000
OPP-1256376000000002625262526252625
OPP-1236171000000969796979697969796979697
OPP-1126581000000000000
OPP-841384000053575357535753575357535753575357
OPP-996073000062506250625062506250625062506250
OPP-12545490183751837518375183750000000
OPP-12375150119119119119119119119119119119119
OPP-1233047083578357835783578357835783570000

 

Table 2 - called Cashflow - has two columns "Month" which identifies the current month (today).

For the other column - "Forecast Cashflow" I want it to return the sum of each of the months across all projects. {the problem}

ie

Mar  sum (revenue month 1)

Apr   Sum (revenue month 2)

May  Sum(revenue month 3) etc...

Month Forecast Cashflow

Mar 
Apr 
May 
Jun 
Jul 
Aug 
Sep 
Oct 
Nov 
Dec 
Jan 
Feb 

 

 

From there I create a dynamic column chart based off various slicers.

 

Getting the summed monthly revenues transposed into the Cashflow table is where I'm stumped.

 

Appreciate any suggestions

0 REPLIES 0

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors