Last seen: Jun 25, 2026
@pakayak Since you want to look for the ProductID and the Site, it's easier to use to use FILTER as it allows you to combine filter criteria by + (...
@alanr @velouria Proved me wrong 🙂
@alanr Your file is full with links to your Sharepoint site and these will obviously not update for us. I've copied the table and pasted it back as ...
@carolina-vidrascu Difficult to answer without more details on how you connect to the folder. You could try the SharePoint.Contens function rather t...
@clilly123 Not sure why it went wrong but you did not have any Date fields in either the pivot table (PT) or the pivot charts (PCs). The PT requi...
Welcome @rigman You chose VLOOKUP so I assume you work with an older version of Excel. But VLOOKUP is not really suitable for this kind of problem. ...
@benjamip With some trial and error I came up with a rather bulky CF formula applied to B2:F29 (pasted below). I added something in the bottom righ...
@robert-forest Thanks for the file. Although the file with only the "All" sheet wouldn't be extremely large (approx. 8MB) I do understand that navi...
@robert-forest But you can separate the Excel data if needed. In separate tabs or even separate files. Then you connect your PBI model to separate ...
@robert-forest Okay! Didn't think clear when I wrote my previous answer. Was on a Mac and than PowerBI doens't work. Not even in the PBI (online) S...
@outavong You are tagging onto a 7 year old post. A lot has happened since then and Mynda did blog about a Gantt charts that allow for daily, weekly...
@robert-forest The link returns the message "This content is not available" so I couldn't look at what you intended to share with us. I suspect it...
@lynnalt I fear that NOW() in PowerBI works similar to NOW() in Excel. It will update to the current date/time upon a refresh. It may be not be answ...
@magickrhythm Difficult to test without a live URL, but in PQ you can use parameters for the parts that vary. You'll have to connect the the website...
@magickrhythm Could you give us an example of such a 'ridiculously long' URL?