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.
Dear community
I have 3 table visuals like below
first table is budget table,
2nd table is actuals
3rd table is also actuals table but in periods.
i need to show this in 1 table
with budget, actuals & variance( Calculated column at end showing difference between budget and actuals)
How do i do this?
Solved! Go to Solution.
I am not sure about that, but you can have a look at this document which might help:
https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/
You can do it in Query Editor.
In Query editor in right hand corner of Home window you can see an option Append Query
Append Query--> Append Querys as New --> Three or more tables
OR
If all the above mentioned columns are from the same table then you can use Matix visual where you can introduce Subteam in Rows, Period in Column and Amounts in Values. Hope this might help.
Mark as answer if it solves your query!
Hi @vjnvinod ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, Please share your data sample with table format so that I could have a copy on it then have test.
Best Regards,
Cherry
I am not sure about that, but you can have a look at this document which might help:
https://www.sqlbi.com/articles/lookup-multiple-values-in-dax/
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 |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |