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