Forum

Hi Darren, You're going in the right direction. To clarify Anders suggestion, the 'show items with no data' option is not available with Power Pivo...

Glad you found some efficiency gains, Jason and thanks for reporting back. However, something concerns me with what you describe. You say: "I ...

Hi Saliha, Your question doesn't explain the issue or desired result. What do you mean "Possible to transpose the data from Pivot table in one cell...

Glad you figured it out, Greg.

Hi Alex, Creating a P&L with Power Pivot is super complicated. Hopefully this post will help point you in the right direction. Mynda

Hi Akshay, Welcome to our forum. I'm not sure I fully understand your question, but give this formula a try: =IF(A1<90,0,IF(A1<=110,400*A1...

Hi Lisa, The last argument in AND is TODAY()< C6 which is the start date which is effectively 11/11/2020 < 1/11/2020 which is FALSE, hence th...

Hi Robert, To copy a chart, select the very outer edge of the chart so the pull handles are activated > CTRL+C > go to where you want to past...

Hi Tracy, The problem with the 'Top' files appears to be formatting. I opened the files and removed all formatting and the queries refreshed withou...

Hi Mariena, These were the updates: Updated: 4.06 Slicers, Timeline Slicers and Sync Slicer now includes the new hierarchical Slicer functional...

Hi Robb, You haven't given a specific example, but hopefully I've understood and the example file provides the answer you were after. Mynda

Hi Lisa, You can just add another Slicer for the start month field. That will filter the list for projects starting in the selected month/s. Myn...

Hi Aye, Like Anders said, that formula uses dynamic arrays. You don't need to enter them with CTRL+SHIFT+ENTER Please advise what version of Ex...

Hi Aye, You should be getting the data with Power Query and then loading it to Power Pivot from there. Then you can edit the query to fix the name ...

My pleasure, Maria. Glad you're finding value in the course 🙂