Last seen: Jul 3, 2025
You can use Value.Divide (Number.From([#"Time Spent#(lf)on Job#(lf)(Hours)"]), 7.25) but better to format column as Integer or decimal before th...
You asked for a Power Query solution, so my answer was related to power query menu, not Excel. Transform tab is in Power Query menu, not in Excel menu...
Hi, Have you tried to pivot the "long" table? Select the DateiName column, then from Transform tab press the button Pivot Column. In the dialog box...
Hi Anthony, I am not using Firestore, never needed to connect to one, you have to follow the process they describe to access data, can't help more unf...
Using the automatic file combiner is not dynamic. It ONLY reads the first file in that folder to get the headers and ignore all other headers from ALL...
Hi Anthony, It does not matter if the intended purpose is a personal application or a global project. You do not offer google a guarantee that you ...
Hi Anthony, You have to study the documentation google provides for Firestore: Their doc say: Use a Google Identity OAuth 2.0 token and a service...
Hi Lionel, Steps to achieve that: 1. Sort datetime column Descending. 2. Edit this step in formula bar, wrap the existing code with Table.Buffer...
and multiple users will work on it in the same time? That is correct That sounds like a conflict, if more than one user will open and refresh th...
Please upload a few sample csv files with different headers and just 1-2 rows of fake data. Will prepare a sample.
The power of using files from a SharePoint folder is that everyonbe with SharePoint rights can update the file; that's not possible when we use a sync...
Actually, the link I provided offers a solution where it does not matter how many columns are in the source files, so you do have an answer. My questi...
You mean that the file that extracts data from sharepoint folder is also located in sharepoint, and multiple users will work on it in the same time? T...
Hi Yifan, From sharepoint, you should be able to Sync that folder or documents library with OneDrive, there should be a Sync option in sharepoint m...
Hi Steven, The easiest way is to split that column by delimiter, using comma as delimiter. Make sure you expand the Advanced Options and choose to ...