Forum

Hi Aileen, Thanks for sharing your file. You need to add a column to your Activity Table (which you can hide) that detects if the row is visible/no...

Hi Diaa, I don't know of a fix for this issue and a Google search didn't have any conclusive fixes, so I'd be inclined to find a workaround like us...

Hi Christine, Purfleet's instructions are for hiding the scroll bars in Excel for the desktop using VBA. I think based on your screenshot that you ...

You'd need to sort by currency and then by date. I'd test some scenarios to make sure it gives the correct result. Mynda

Hi Aileen, Welcome to our forum! As I mentioned in reply to your question via email, you need to attach your Excel file so we can see what you're r...

Hi David, You need to write a DAX measure using SUMX to calculate the unit price x qty shipped e.g. in the attached file: Check Total =SUMX(...

Hi Mohamed, Thanks for the video that very clearly displays the issue. As Anders said, you should simply right-click the ALL query and change the L...

Hi Bax, In the attached file you can see I created a dynamic list of the columns called 'ColsToAverage' and used that to create the Average column ...

Hi Francis, When you do a merge you select the matching columns one by one i.e. as per your example above: Date > Date and Currency > Currenc...

Hi Peter, The matrix you see in Power BI is a visual, much like any other visual e.g. charts, and you cannot export Power BI visuals to Excel. The ...

Hi Carolina, I'm not aware of how to do this, sorry. It's not something I cover in the course, so it's definitely outside the scope. If you don't h...

Hi David, It doesn't require Power Query. Just Power Pivot, but Power Pivot is not available in all versions of Excel. Please check this list and e...

Hi, thanks for sharing your file. First, your calendar table must have consecutive dates if you want to use the time intelligence functions like SAMEP...

Hi David, When you insert a calculated field the calculation is operating on the aggregated values for the field. You can see this in the case of p...

Hi Philippa, Thanks for sharing your file. I can see that the problem is caused by the wrong layout for the source data. i.e. the data is already p...