cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yasminbloch Frequent Visitor
Frequent Visitor

FTE's actual vs. budget vs. forecast

Hi,

 

I want to compare FTE's gaps between actual vs. budget vs. forecast.

I created 3 tables, each one has the same dimension and one measure. The measure is diffrent according to the table (actual vs. budget vs. forecast).

How can I link them in order to make calculations on the gaps?

should I build diffrent the DB?

 

Many thanks,

Yasmin

3 REPLIES 3
Yasminbloch Frequent Visitor
Frequent Visitor

Budget FTE vs. actual vs. Forecast

Hi,

 

I'm trying to analyze budget vs. actual vs. Forecast FTE's.

I created 3 tabels, in each one there are the same dimension and one measere. This measure is difrrent in each table, since it's reflect: Budget, Actual or Forecast.

How can I link them and creat one DB that I can analyze in Power BI?

 

Many thanks,

Yasmin

Moderator Eric_Zhang
Moderator

Re: FTE's actual vs. budget vs. forecast


@Yasminbloch wrote:

Hi,

 

I want to compare FTE's gaps between actual vs. budget vs. forecast.

I created 3 tables, each one has the same dimension and one measure. The measure is diffrent according to the table (actual vs. budget vs. forecast).

How can I link them in order to make calculations on the gaps?

should I build diffrent the DB?

 

Many thanks,

Yasmin


@Yasminbloch

I think there's a FTE table in your case? Per my understanding, you can connect those 3 tables to the FTE individually.

 

For further advice, please post some sample data and expected output. To have a better understanding of your case, you can upload a sample pbix file. Just upload to Onedrive or any web storage and share the link. Do note to mask sensitive data before uploading.

Highlighted
Yasminbloch Frequent Visitor
Frequent Visitor

Re: FTE's actual vs. budget vs. forecast

Hi,

 

Thank you! I added an example below. Will appreciate your response!

 

Table1:

Fields: Account, AccountID, Country, #FTE actual (measure)

Table2:

Fields: Account, AccountID, Country, #FTE Budet (measure)

Table3:

Fields: Account, AccountID, Country, #FTE Forecast (measure)

 

My Q: How to link between these 3 tables? So if I filter on specific Account/ AccountID, I could see the #FTE: Actual, Budget, Forecast.

 

Thx!!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 276 members 3,185 guests
Please welcome our newest community members: