Last seen: May 22, 2025
Which version (and build, if 365) of Office do you have?
Right-click the link and choose Save Link As... instead of just clicking on the link normally.
FWIW, if you don't want the additional column, you can amend the FILTER formula to do the same work: =FILTER(Source[Name Product],BYROW(Source[Cate...
For 2019 I think you can just remove the FILTER function from Riny's formula and replace it with IF: =TEXTJOIN("/",,IF(Table1[item Code]=B4,Ta...
What is your connection? I have several reports that run off files in sharepoint that are open (usually in Teams) most of the time, and have never had...
I don't think so. You can add one rank column that ranks on both of those columns, but not two separate ranking columns in one operation.
If you just want it to look like that, then yes, certainly.
The data in that field is not a List
If you click to the right of one of the Error values, what does it show you for the error?
I'd definitely use a table. What's the original data source? Can you use Power Query to get the data from it directly into the table, rather than copy...
I'm not aware of any way to force users into their own sheet views. I don't really follow your question about Lists - can you elaborate? My th...
Power Query is part of Power BI, so you can do all the same data manipulation, before getting into the presentation aspects.
Yes, you can set up slicers and filters and what one user does will not affect what another user sees.
I know you can read/write data in Sharepoint lists using ADO, but I'm not sure if that will work to an Excel file data source on SP/OD. If I find some...
It would depend somewhat on the circumstances. I was thinking ADO, though I'm not sure how well that will work with Sharepoint as a back-end file loca...