Forum Discussion
Multiply Data in One Table by a Percentage from Another Table
Hi racer25 ,
Don’t try to merge those two big tables in Power Query — it’ll freeze Power BI.
Instead, keep them separate and use a relationship (Many-to-One from Fee Income to Client Accounting). Then create a measure like this:
Net Allocated = SUMX( FIS_FEEINCOMESPLIT, RELATED(CAC_CKUEBTACCITYBTUBG[Net]) * FIS_FEEINCOMESPLIT[Percentage] )This way you multiply Net by the department percentage without heavy joins. Much faster and scalable.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.
Super UserHi racer25 ,
Don’t try to merge those two big tables in Power Query — it’ll freeze Power BI.
Instead, keep them separate and use a relationship (Many-to-One from Fee Income to Client Accounting). Then create a measure like this:
Net Allocated =
SUMX(
FIS_FEEINCOMESPLIT,
RELATED(CAC_CKUEBTACCITYBTUBG[Net]) * FIS_FEEINCOMESPLIT[Percentage]
)This way you multiply Net by the department percentage without heavy joins. Much faster and scalable.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.