Forum Discussion
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 formu...
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 👍