How to make/create OR operator between fields in Power BI ?

szakharov7723

Board Regular
Joined
Jun 22, 2018
Messages
85
Office Version
2019
Platform
Windows
So I have 2 fields
Problem
Work Performed

Both can contain similar information, thus both can contain specific info.
So far apps provide only AND operator. If I create filter for Problem and Work Performed. I will either miss information if one of the fields doesn't contain keyword, or I don't have everything summarized in one report.

Is there any way to create OR operator between fields ?
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,095,726
Messages
5,446,151
Members
405,386
Latest member
xcookiemonster64

This Week's Hot Topics

Top