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!!