Forum

Hi Nicolas, Try this formula: =SUMIFS(F1:F7,E1:E7,">="&DATE(2012,3,1),E1:E7,"<="&DATE(2012,3,31)) If you want the date field to...

Hi John, Welcome to our forum. Give the cells C5:C13 the name 'List'. then use this formula in cell B5 and copy down: =INDEX($C$5:$D$13,IF(SUMPR...

Glad you are up and running again, Gary. I agree, it's a shame you couldn't get to the bottom of it. Mynda

Hi Shantanu, It depends...If you loaded your data into Power BI via Excel file tab > Publish > Upload your workbook to Power BI then Power BI...

Hi Mike, Try updating your install of Excel to see if the Sybase connector is available. I wouldn't waste time on other things until you can test t...

Hi Payal, The 2 variable tables require two inputs that are numbers, as explained here. The variable row 98 contains text. This needs to contain nu...

More feedback: Have you also disabled background refresh? Can you try setting the Supported Row Reduction Clauses property? And this: Th...

Hi Nikki, Welcome to our forum! If you're using Office 365 then you can use the UNIQUE function to return the list ignoring errors and blanks. A...

Hi DeNae, Have you tried adding the Library field to the row labels under the Document field? Mynda

It's not something fixable with a trick, so to speak. Let me put it this way, if you take customer 7996, how would you like the data presented? If ...

Hi Payal, I doubt it has anything to do with the data being on separate tabs. You haven't been specific about what isn't working. Mynda

Hi Claudia, I don't think your data is structured correctly for that. Take customer 7996 for example. They attended two events. Which event do you ...

Hi Shantanu, Congratulations on your progress! Yes, you can use the Export workbook data to Power BI tool. See session 8.04 of the Power BI cour...

Hi Maureen, It's great to see that the data is in a tabular format and that you already use PivotTables to summarise it. I would be aiming to cr...

Hi Jackee, We'll need a bit more information. Can you supply the workbooks you want the data copied from/to and explain in detail what it is you w...