Help recreating a unique table in excel

[dwhittaker1]

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

[v-karpurapud · Accepted solution]

Hello @dwhittaker1 

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.

1. Create a Disconnected Table for Measure Names and create a Measure to Switch Between Values.
2. 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!

[dwhittaker1]

@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

[danextian]

Hi @dwhittaker1 

This approach requires a disconnected table along with measures that reference it. Attached is a sample PBIX file using this method.