Forum

Glad you go there in the end, Sid. Tenacity will get you a long way

It's difficult to picture what you want without an example, file, but you can enter the FORECAST functions manually on a single sheet. You don't have ...

Hi Angel, Welcome to the forum! Please see the lessons in session 10 on using the Time Intelligence functions. If you get stuck, please come bac...

Thanks for sharing your file, Irfan. You need to put group boxes around the two sets of radio buttons. I tested it and that resolved the issue. If you...

Hi Sid, The formula isn't written correctly. If your criteria are AND, you must separate them with && e.g. =CALCULATE(COUNTROWS(Opportun...

Hi Justin, Instead of using the value filter for top 3 in the PivotTable, you can create a regular chart from the PivotTable that only references t...

Hi Sid, Have you tried adding a filter to calculate for && NOT(ISBLANK([date])) Mynda

Hi Jon, You can try adding another filter criteria to CALCULATE: [Type] <> "Opening Customers" Mynda

Hi Rod, Welcome to our forum! Tables do not allow editing when the sheet is protected. You need to write some VBA code that unprotects the shee...

Hi Cristina, Welcome to our forum! Please see this on grouped running totals in Power Query. Mynda

Hi Sunny, Welcome to our forum. Please share your Excel file, or if it's too big, share a small mockup that illustrates the problem. Mynda

You could try importing your Excel file into Power BI instead. This will bring in the queries and data model if you have one. File tab > Import.

If you want Excel to sum ABC and ABCD together, then you could use Power Query to replace ABCD with ABC so Excel knows they are the same. Alternativel...

Hi Angela, There must be a bug in that version of Excel. You can import the data by copying and pasting it in for the purpose of moving on to the n...

Did you try copying from the same workbook that the Power Pivot model is in?