Forum Discussion

GB74's avatar
GB74
Frequent Visitor
4 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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]))

amitchandak's avatar
amitchandak
Super User
4 years ago

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]))

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Hola Community!!!

I am a begginer in the powerBi and I did not know how to solve this problem with the issue of calculating working days between two dates because I see "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression, which is not allowed."

I attach my code to help me.

thanks!!

RevisedDate vs ClearDate =
CALCULATE(
COUNTROWS('Auto Calendar') ,
DATESBETWEEN('AutoCalendar'[Date], IoBl[RevisedDate], IoBl[ClearDate]),
'Auto-calendar'[working days]= TRUE(),
ALL(IoBl)
)