Last seen: Jun 29, 2026
Hi Alex, Thanks for sharing your file, however I couldn't follow what you mean by: "after this i need somehow to lookup values from Validation Date...
Hi Jon, Thanks for sharing a sample file.This makes it a lot easier to quickly pinpoint the problem. Your measure is returning a zero if there i...
Hi Ibrahim, In Excel 2016 you click the' Add to Data Model' button on the Power Pivot tab. It creates a linked table, although it doesn't have the ...
Hi Emily, Power Pivot ignores the time portion of the date. Just format the date column as data type; 'Date', and it should be fine. Mynda
Hi again, I've had word that this connector is to be deprecated due to lack of support on the SAP side. If you do have it, I wouldn't use it becaus...
Hi Emily, If you put the Date field (i.e. the field that contains the whole date, not just the day), in the Rows area or Filters are of your PivotT...
Hi Eliane, According to this post it should be available under the "From Other Sources" menu, but I don't have it. I've put a call out to Microsoft...
Hi Gayle, Glad you figured it out. If you get stuck with your next challenge just start a new thread and we'll take a look. Mynda
Hi Gayle, It's a bit tricky without seeing what you mean, but if you select a cell in the PivotTable column that contains the nil values, then clic...
Hi Ahmed, The process is the same except you select the data in columns I:K before inserting your stacked column chart. After that you follow ...
Hi Jessica, It looks like the sheet name is >>:<< and the sum is simply picking up the value in cell S46 of that sheet. Mynda
Hi Mey, Here are some tutorials on the solutions provided by Sunny that will help you answer these questions yourself going forward: IF and OR, ...
Hi Kenny, I thought for a second on how to edit the formula in the same column too, but I'm lazy and it was going to require learning how those dat...
Hi Jeroen, You can use the XIRR function to calculate CAGR: Let us know if you get stuck with it. Mynda
Hi Kenny, I don't profess to understand Julian dates, but you could just add another Custom Column to adjust the date returned by the above formula...