IF/AND/OR statement equivalent for Power BI

[edins425]

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!

[DOLEARY85]

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 👍