Forum

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.

Hi Dieneba, The benefit of using Power Query over Excel is that it records the steps so you can automate the process and the next time you need to ...

Hi Mohamed, Your file didn't get attached. You need to click the 'start upload' button after selecting your file and then wait for the grey check m...