Forum Discussion

edins425's avatar
edins425
New Member
3 years ago

IF/AND/OR statement equivalent for Power BI

Hi, something I can do in excel and trying to replicate in my Power BI dataset is creating a column which looks at 2 other columns to report back "Labor", "Non-Labor" or blank. Here's the excel formula which does just that but I'm new to Power BI and can't figure out how to do it in Power BI Desktop.

 

=IF(Q2="revenues","",IF(AND(T2>="509510", T2<="520350"), "Labor", "Non-labor"))

 

Thanks in advance!

Need Help

1 Reply

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    Hi,

     

    I'm not 100% sure without seeing what you expect the data to look like but you could try this in a calculated column:  

     

    Column = if('Table'[Q2]="revenues","",if(and('Table'[T2]>=509510,'Table'[T2]<=520350),"Labor", "Non-labor"))
     
    this is the data i used:
     

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍