Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

How to get variance from two Comparision tables



table 1 having Scenario,Year and Period Slicers.

Table 2 having same slicers from same table,

Using edit interactions , stoped intercation with Table 1 and table 2 to compare both tables at a time.



So now my requirement is need to add 3rd table with difference of Table 1 , Table2 values.


If table 1 user select scenario as Actual,Year as 2023, Period as May

If table 2 user select scenario as Fcast ,Year as 2023, Period as May


Table 3 values should difference of Table 1 - Table 2 .


Ex: Selected values of table 1 Quantity - selected values of table 2 Quantity.


Can anyone help me how to derive a measure  based on selected values of same slicers. 

FYI - Backend having huge data unable to take duplicate table.



Super User
Super User

@VikramAdi , You need independent table/s for scenario to compare the two


Compare Categorical Data Using Slicers, and Compare Two Brands/Categories/Cities:


Power BI How to use/compare two Date/Period slicers:

Helper I
Helper I

Need support here.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors