Forum Discussion

adin's avatar
adin
Helper I
5 years ago
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 ...
Need Help
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    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.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

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.