Forum Discussion
Solved
A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp
Hi, I'm a newish user to PowerBI and struggling with a calculation. I'm effectively trying to do a SUMIF, but I know you can't do that within PowerBI. I want to show the sum of the value of all op...
GB74 , Formula like. Try formula like
Open Order Value due this month = Calculate(Sum('Sales Orders'[Value]),filter('Sales Orders','Sales Orders'[Delivery Month]='Sales Orders'[Current Month]))
GB74 , Formula like. Try formula like
Open Order Value due this month = Calculate(Sum('Sales Orders'[Value]),filter('Sales Orders','Sales Orders'[Delivery Month]='Sales Orders'[Current Month]))
Thank you so much.
The formula works correctly. The value displayed doesn't look correct, but I can go from there to see what is going wrong.