Forum Discussion
How To Calculate Mean For Column ONLY IF value In One Table Matches Another
I am currently calculating Total Sums, Total Quantities, and then computing Means grouping by another column in a table. The identifier is a Unique ID.
I have another table with a Unique ID identifier. I need to compute the Mean for this column as well. I do not know how to calculate this.
I basically need a formula that does: IF(ColumnAInTableB matches ColumnAInTableA), then Average((SumOfColumnBInTableA)/(AverageQuantityOfColumnCInTableA)GroupedBy ColumnDInTableA)), and return just that average number for each instance of ColumnAInTableB.
1 Reply
If you create a new column like this in table A, you will know that if Table B has data for that id or not
New column =countx(filter([tableB],tableA[id]=tableB[id]),table2[id]))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
