Forum

Hi Sarfraz, In that case you can ask Power Query to match 3 columns. See example attached. Mynda

Hi Sarfraz, All example dashboards (other than those in my Excel Dashboard course) that I have built are already available to download for free fro...

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