Last seen: Jun 29, 2026
Hi Stephanie, In your formula the second and third arguments in the DATESBETWEEN function (StartDate, EndDate) are referencing a whole column, but ...
Great. Just be sure to set up your model correctly or you can get erroneous results. You can learn Power Pivot in my course here:
Hi Ibrahim, Thanks for the screenshots. What you're looking at is the Power Pivot model in Excel 2016. Those references in the formula are to the T...
You can't do this with regular PivotTables the way you want. Your options are to add these formulas in columns outside of the PivotTable. You could le...
Hi Adele, Power BI can only have one model, just like Excel can only have one Power Pivot model per file. Power Query has no limit on the number of...
Hi Declan, It's difficult to give you formula advice without seeing your file, but the process you describe is something Power Query (available in ...
Hi Adele, Do any of the workbooks contain all of the odata tables? I'm just wondering if you can create a PivotTable to return the totals that you ...
Hi Hava, I'm not following, sorry. Please clarify what formulas aren't working the way you want, and what your expected result would be for a coupl...
Great 🙂 glad I could help.
Hi Cele, I added some new tutorials to the course (session 7) but, you must not have renewed your membership. If you want to share your file her...
Yes, I'm afraid I don't know of any workaround for that with Power Pivot. With regular PivotTables there is an option to 'Show items with no data' in ...
Hi Jessica, It's very difficult to say without seeing the file, but there might be a clue in the difference in the radio button options given in th...
Hi Alex, Thanks for clarifying. In the attached file I took a copy of your original data and removed columns B:D so I could create these using Powe...
Ok, that makes sense. But, that also means that your Slicer will show every item since they will contain a zero, as opposed to having 'no data'. My...
Hi Cele, You can use a query parameter to set the date you want to use. See lesson 7.01 of the Power Query course. Mynda