Forum

Good luck, Sally!

Hi Shawn, Are you able to merge the two reports into one table? Presumably there is a 'terminated date' column and any active employees will have a...

Hi Dieneba, There's no operations in the Middle East, so when you filter for that department, no results are returned. If you change the Department...

Hi Sally, I'm assuming that your Project data is online since you're looking for a URL. If so, at this link under point number 4. Determine your Pr...

Sounds like you need to Pivot the data. Select the Heading column > Transform tab > Pivot Column. Select the Values column from the drop down an...

Hi Jennifer, The Pay Period slicer will only grey out if the Fiscal Year Slicer is also connected to both PivotTables or, the Pay Period slicer is ...

Hi Alison, I've moved this topic to the Power Pivot forum. It's impossible to troubleshoot without seeing your file, or at least a desensitised...

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