Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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
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.
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!!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |