Forum

Hi Alina, Welcome to our forum. If you know how to do it in Power Pivot then it's the same in Power BI because Power BI uses Power Pivot for the...

Hi Mike, Duplicate the query, then unpivot the columns containing TRUE/FALSE. Filter the duplicated query for only TRUE rows and remove the colu...

Hi Alan, You can use form control check boxes to choose when to include/exclude data. The form control returns a Boolean TRUE or FALSE result. When...

Hi Larry, Can you please start a new thread for the question above as it's a different topic. Thanks for understanding. Mynda

Glad you got it working 🙂

Hi Jacqueline, Ah, I see it's Google Sheets, not Excel. We don't support Google Sheets questions, but since this is a copy of an Excel function, yo...

Thanks, but I can't open the link. I've requested access. Hopefully you've received a message to that effect and can approve it. Mynda

Hi Peter, If you need to do a transformation like unpivot, then this needs to be done at the sample query level, i.e. before the data gets to the f...

Hi Azeemus, You don't have the date field in the PivotTable. You can only filter on a date if you add the date field somewhere in the PivotTable. P...

It sounds like your data is not in a tabular format. Are you able to upload a sample Excel file so we can help you further?

Glad it’s working! Good question about which functions can handle non-contiguous ranges. It’ll be functions that take multiple ranges e.g. SUM, AVE...

Hi Alan, The SEARCH function doesn't take non-contiguous ranges. If the other cells in column BO don't contain a comma followed by a space i.e. the...

Hi, If it's not returning the desired result, (maybe you're averaging the data), but it's likely a limitation of calculated columns in regular Pivo...

Hi Larry, Great question. I don't specifically cover tricks for working with big data in my course. You could try Table.Buffer and see if that ...

Hi Nadeem, Thanks for sharing your file. It can't be done. You'd need to create a separate PivotTable and remove the Zone field to get the figures ...