Creating a Dax query to get sum of a column from Table A if the record matches in Table B
I have 2 tables 1. Gold_Staff_Campaign 2. FX_Data i want to create a DAX formula to calculate the Total Profit residing in Table FX_Data under column "Profit" if the Account Number in Gold_Staff_Campaign matches with Account Number in FX_Data. I have tried below formula but its not working 1. ProfitColumn = VAR CurrentFORACID = SELECTCOLUMNS ( Gold_Diwali_Campaign, "FORACID", Gold_Diwali_Campaign[FORACID] ) RETURN CALCULATE ( SUM ( FX_Data_2022_Onwards[Profit w.r.t real time rate(AED)] ), FILTER ( FX_Data_2022_Onwards, FX_Data_2022_Onwards[FORACID] = CurrentFORACID ),ALL ( Gold_Diwali_Campaign ) )
Merged Tables
I attempted to merge two tables one from an excel spreadsheet & the other from an SQL table. To do this I created a thrid table with the columns that I needed from both tables. The excel spreadsheet will contain updates on training completions using a learner's email, training name & status. When I added an additional rows to my excel spreadsheet it updated the table but not as I would have expected in the merged table. For example I have a learner in the table twice & it updated both records & ignored the training name. I believe becuase the merge is set to email that it updated them both. I tried to set it 1st to email & 2nd to training name but that created more issue. I thought also maybe the relationship between the table is not correct being email to email (many to single). Any assistance will be appreciated. Thanks