Last seen: Feb 6, 2025
Short answer: Not directly. You can’t simply reference “cell A2” or “the current row’s postal code” in the OData feed URL box. However, you can achiev...
Hi, As mentioned in the very first message in this topic, the discussion is related to Excel Forms article: Go to that page, there is a downloa...
Possible Reasons and Suggested Solutions Event Not Triggering: Check the Code Location: Ensure that the code is placed in the Overview worksheet...
Hi David, OneDrive paths are specific to individual users and cause compatibility issues. Using SharePoint ensures that file paths are universal an...
Hi Sean, Normalization usually means splitting data into multiple related tables, this is what you want to do? Because most databases have unique stru...
To extract the region names from a cell with mixed content (regions and additional comments) in Excel, here’s a solution using formulas, or VBA to au...
To implement an audit sampling process that adjusts deficits across priorities (P1, P2, P3, P4) while ensuring sampling aligns as closely as possible ...
Best is to provide a sample file so we can test, even if the subject seems simple to replicate, this way you'll get faster responses. In Excel, mainta...
Tracking and fixing hard typed column names in Get and Transform is a waste of time, will never make it flexible. When a new file will be added in the...
Let's break it down: Components of the Line: List.Buffer(Source[Gain]) : This converts the Gain column from your Source table into a bu...
To accomplish your goal of resetting the position to 0 when the compounded return reaches -1% or lower, you can modify your fxRunningTotal and fxGroup...
Hi Cristopher, Combine and Transform is not a good way to go, it's not yet flexible enough. See this post for a more flexible solution:
Well, I have to be honest and give credit to latest ChatGPT 4o, I was testing it to see if it is able to provide a viable solution based on your (very...
In Power Query, when making web requests to APIs, the behavior can indeed seem a bit different compared to other environments where you explicitly spe...
You're correct in your observation: when you create a calculation group in Power BI, the calculation group essentially replaces the default measure wi...