Forum

Hi Alan, Try this: =SUMPRODUCT(--ISNUMBER(SEARCH(", ",$BO$2:$BO$21)))*2 Adjust the cell range to suit. Mynda

Welcome to our forum! The IF function doesn't operate over a whole column, it checks a single cell. Therefore your formula probably should be more ...

Hi Nadeem, Can you try uploading your file again, please. It appears something went wrong as I can't open it. That said, if you want to add a ne...

Hi Erika, Your column names should be surrounded in single quotes/apostrophes. I usually just double click the fields to add them to the formula. T...

🙂 no worries. As an existing member you can use this coupon to take 20% off: MOTHVIP

What's the error?

Hi Allan, I cover this in the DAX section of my Power Pivot course, but I see you're not a member of that. You can use the ALL function to remove f...

Hi Jeff, Welcome to our forum! Are you able to share the PQ file and source file, or at least an example so I can troubleshoot? One idea...have ...

They shouldn't be in the filters at all if they're not in the Power Pivot model. If you're able to share your Excel file with me I can take a look. Yo...

Hi Christoph, Yes, you can and should use Power Query to get the data and load directly to Power Pivot. If the SAP you speak of is a SAP HANA da...

Hi Pinesh, Welcome to our forum! Presumably full time is -1 and part time is 0. In which case, ADD the 'Full_Time?' field to the columns area an...

Hi Carlos, If you want to prevent a chart (le'ts call it Chart A) from being cross filtered, you need to select all of the other charts (one by one...

Hi Jacqueline, Welcome to our forum! You can use the COUNTIFS function to count the number of students that have "Yes" in column E AND match the...

Hi Jeff, Welcome to our forum! It's difficult to say without seeing the structure of your source data and an example of the desired result. Can ...

Thanks for your kind words, Jan! Glad you fixed the issues in your query.