Forum Discussion
Calculated Column Depends on another Calculated Column (Race condition)
Hi parry2k
Your reply was not the answer but it did lead me to it.
The problem was some of my Relations were way off, so I think Power BI couldn't figure out what was what.
But anyway thanks for pointing in the right direction 😄
Hi parry2k
Your reply was not the answer but it did lead me to it.
The problem was some of my Relations were way off, so I think Power BI couldn't figure out what was what.
But anyway thanks for pointing in the right direction 😄
Hi Anonymous ,
It seems that there is no relationship between two tables, right? You could try to refer to below expression to create calculated column
Column = CALCULATE(SUM('Order table'[Seller Scalar]))/MINX(FILTER('Part Numbers','Part Numbers'[Part Number]=EARLIER('Order table'[Part Number])),'Part Numbers'[Total Scalar])
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous glad to hear that issue is resolved, that's what matters. cheers!
