Forum

Hi Allison, The CUBE functions are unlikely to be the cause. It's more likely that you have a PivotTable that's in the same column as your up/down ...

Hi Jennifer, I am not able to replicate the issue. See file attached. Please modify this file by adding data that replicates the problem you're hav...

You can use this DAX measure: =CALCULATE(SUM([SalesAmount]),Table1[id] <= MAX(Table1[id]), ALL(Table1[Customer])) If you'd like to learn more...

Hi Stephan,, I see someone has responded in the Chandoo forum. So I won't waste my time here. Please note that you should also be declaring that...

Hi Amin, Thanks for sharing your file. I'm not sure I understand your question and desired result. If you simply want the Date Slicer on the Dashbo...

If the reference numbers are the same, then what is the logic to tell the transactions apart? Please provide examples based on your file so I can foll...

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...