Forum

Hi Dieneba, I'm going to terminate this thread because you are also emailing me about it, so best just to have one place for the questions so we do...

Hi Dieneba, I think Riny may have misunderstood the question as it appears to me that you simply want to add another table to the query data source...

Hi Miguel, The correct way to approach this is to use Power Query to combine the source data that the two PivotTables are based on, rather than bui...

Hi Dieneba, I’m not following the explanation. E.g. you say: IF in Feb 23 (column A) the Email [email protected] (B) has Application 1, 2 in column...

Hi Dieneba, If you look at the Source step you can see the query is referring to the table called Tableau3. That table is on the sheet called Repea...

Hi Philip, That would be handy, however there's no built in way, but this post explains how you can do it with DAX Studio. Mynda

Hi tom, Thanks for clarifying. I think the best you can do is take the file I already uploaded and add another column for "Remaining contingency fo...

Hi Fiona, It's great to see you're practicing! In the zip file containing all the files for the course there is a file called _supporting_file_inde...

Hi Stephan, I recommend you rethink your file layout and format the data in a Tabular layout so that you can use tools like PivotTables, SUMIFS etc...

Hi Sarfraz You can use Power Query to do this, as explained in this tutorial. Mynda

Hi Tom, Thanks for sharing a file with your before and after results. I wish everyone would do this! That said, I think there may be some errors in...

Hi Mohamed, Thanks for providing the file. I've converted the data in the Forecast sheet to a table and replaced the dynamic array formulas with st...

The Power Query editor gives you a 1000 row snapshot of the data. It does this to enable it to remain agile when you perform steps on the data in the ...

Hi Dieneba, Without a mock-up example of the final output you'd like to see, I can't give you step by step. e.g. in that file there are subtotals, ...

Probably best, however if your query doesn't interact with external sources, like web pages, then the privacy settings aren't doing anything.