Forum Discussion
Multiplying Rows & Columns to calculate Yield
Hello Fellow PBI Users! I always seem to overcompliate and confuse myself using DAX but I was hoping to get some help. What I would like to achieve is a total yield for a specifc group by mul...
A DAX formula depends on the tables, columns and relationships. It is impossible to help you unless you provide all this information.
Hi Matt,
Here is the Data
Yes, that is the data. But which tables, which columns, what relationships? Power BI is not like Excel. You can’t look at numbers on the page like you have presented and work out the formula. You must consider the 3 things I mentioned.
Is this enough info? Thanks.
Hi Maykel,
Please refer to the snapshot below. Is it what you'd like?
Measure = PRODUCT(Table1[Program Yield])
Best Regards,
Dale
