Forum

Hi Karen, Can you add more details, a screenshot, what line of code failed? There are not enough details in your message to understand what happens...

Looks like alphabetical sort, so format is not date, even if it looks like a date. Can you upload a sample file that replicates the problem?

You can try They provide a free plan with 5 thousand API sessions included/month

Hi Francine, You should convert all those steps into a function with 2 arguments: source table and total column name, will make things easy. You...

Hi Hans, Can you upload a sample file that replicates your errors please?

Hi Kagiso, Data query combines 2 tables: Transactions and Budget. If the 2 tables don't have the same structure (headers), the table that is missin...

Hi Graeme, If there are a lot of data transformations in the query that makes it slow, you can save the transformation output table as a separate x...

Hi Boris, Move the fields that should be aggregated from Rows section to Values section, as in the image attached:

Hi Boris, When you collapse a field, only fields from Values section of the pivot table will be aggregated according to your settings (Sum, Average). ...

Hi Lili, Colors in pivot tables are not working the same way as regular charts, this might help:

Hi Adam, In excel, you have tools in Formula Auditing group from Formulas tab in ribbon. Trace precedents and Trace Dependents will give you too...

Hi Jack, I don't think there is anything wrong in the charts, what you think is wrong? What I see in the charts reflects the data you have in ot...

Hi Abdul, P$4 and G$4 references are locked to row 4, if you copy the formula down will still look into row 4, maybe this is the problem? If so, remov...

Hi Scotty, You have the microsoft instructions for SAP here: You will have to install from SAP support center the SAP HANA ODBC driver they pr...

There is a mistake in my formula: =if List.PositionOf(KeysList, Training_Report[User Full Name] & Training_Report[Curriculum Title])>-1 then...