Forum Discussion
Help recreating a unique table in excel
I would like to recreate the table in the screenshot below. I am wondering if the best way to do this would be a calculated table but I am im not sure and I am open to suggestions.
In the table below
sales target and sales actuals is raw data from my data set.
Difference is a calculation (Sales actuals less sales target)
Attainment is a calculation(Sales actuals/Sales target)
YTD Column is a calcaution
Total column is a calculation
| Source | Date | Sales |
| ACTUALS | 1/1/2025 | 21138 |
| ACTUALS | 1/2/2025 | 21097 |
| TARGET | 1/1/2025 | 21666 |
| TARGET | 1/2/2025 | 24042 |
Hello Anonymous
Thank you for reaching out to the Microsoft Community Forum.
Thank you danextian for your prompt response.
To recreate the table in Power BI, use a Disconnected Table and a SWITCH DAX measure.
- Create a Disconnected Table for Measure Names and create a Measure to Switch Between Values.
- Next, add a Matrix Visual from the Visualizations pane.
I have attached a PBIX file for a more detailed understanding. Please review it:
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank You!
3 Replies
- danextian
Super User
Hi Anonymous
This approach requires a disconnected table along with measures that reference it. Attached is a sample PBIX file using this method.
danextian thank you this is a good start, is there a way to add the difference measure and attainment calculation to the row of this table as shown below
v-karpurapudCommunity Support
Hello Anonymous
Thank you for reaching out to the Microsoft Community Forum.
Thank you danextian for your prompt response.
To recreate the table in Power BI, use a Disconnected Table and a SWITCH DAX measure.
- Create a Disconnected Table for Measure Names and create a Measure to Switch Between Values.
- Next, add a Matrix Visual from the Visualizations pane.
I have attached a PBIX file for a more detailed understanding. Please review it:
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank You!
