cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Framboosje Regular Visitor
Regular Visitor

if statement

 

Hi s

I want a formula that give me the result 1 if an employee has written hours on project A or C

see picture below

 

 

if statement.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: if statement

If you want a 1 even with the Employee 3, Project Z line because Employee 3 billed to Project A then you will likely need to use EARLIER if you want this as a column. You would use that to create a temp table VAR that you could then use the IN operator to test if Project A or Project C exists in that temp table. See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


1 REPLY 1
Super User
Super User

Re: if statement

If you want a 1 even with the Employee 3, Project Z line because Employee 3 billed to Project A then you will likely need to use EARLIER if you want this as a column. You would use that to create a temp table VAR that you could then use the IN operator to test if Project A or Project C exists in that temp table. See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!