Forum Discussion
Solved
Variable Virtual Table column reference
Hi guys, I need to combine select column from two tables and then run a calc over the top of the union of these two tables but am having trouble pulling out the reference columns and running the ...
Hi adin ,
According to your dax formula, the reason for the error is that the parameter of the sum function comes from a specific column in the data source, and "c_Loan_Amount" in the above expression is a virtual column created. Therefore an error is returned.
refer to official document: SUM function (DAX) - DAX | Microsoft Docs
If it still doesn't solve your problem, can you provide test data (delete sensitive information), because I can't do further tests with the formula alone. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The error I'm getting is "the SUM function only accepts a column reference as an argument."