Forum Discussion

DeeBali's avatar
DeeBali
Icon for Helper I rankHelper I
2 years ago
Solved

Display Common values between multiple tables and display them in a new table

Hello Fabric Community,   I need some assistance with DAX for my project. I have multiple month tables labeled as "01 2024" , "02 2024" etc.. and each table has a column called "Email Address". I n...
  • FreemanZ's avatar
    FreemanZ
    2 years ago

    yes, indeed. 

    1) Load all the monthly tables to Power Query

    2) add a mm-yyyy column accordingly in each monthly table

    3) append all monthly tables

    (all three steps in Power Query)

     

    then do the analysis with Power BI desktop or excel. 

talespin's avatar
talespin
Icon for Solution Sage rankSolution Sage
2 years ago

hi DeeBali 

 

Joins are expensive, I would reconned you do it in Power Query. How big are your tables?

DeeBali's avatar
DeeBali
Icon for Helper I rankHelper I
2 years ago

each month has about 5000 rows worth of data. Thank you.