I'm attaching a file with sample data. All the columns in green work fine. The ones in red keep giving me an error message. I've checked the syntax and brackets and I now know I am missing something. These formulas both work fine in Excel...thanks as always.
Hi Anne,
Power Pivot OR functions are limited to two criteria. You have 3. Really these types of formulas are best done in Power Query (not just because they don't have a 2 OR limit), before loading your data into Power Pivot. It's more efficient for Power Query to add calculated columns and leave Power Pivot for measures.
Mynda
Well at least I now know I wasn't losing my (Excel) mind completely! OK, so can I structure those formulas the same in Power Query or where would I find the syntax for them? Thanks a mil.
Session 6.12 and 6.13 🙂
