FTE's actual vs. budget vs. forecast

[Yasminbloch]

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

[Eric_Zhang]

---

@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.

[Yasminbloch]

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

[Yasminbloch]

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