Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to calculate the difference between columns from different datasets?

Hi,

 

I am pretty new to PowerBI. 

 

I have two datasets: one from Q2 and one from Q4. I would like to calculate the difference between certain columns of these datasets. I found how to write a formula using DAX for columns in the same dataset, but how to do it for two different datasets?

 

 

 

Need Help
Show and Tell

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Consider your "datasets" to be independent fact tables.   Next step is to create dimension tables for each of the columns you want to compare (by referencing a combination of your two queries and extracting unique values).  Then wire your data model and create visuals based on the dimensions.