bigwill29

I'm doing a terrible job explaining this but I have 2 tables on a tab together. When I refresh them and the tables have values to populate there are no issues and it works as expected. The issue arises when the tables refresh with no results (which is correct) the last row of data prior to refresh is populated above the table. Everything works as expected except the remaining last row from before the refresh. These are tables without headers.

Table refresh is set to "Insert cells for new data, delete unused cells"

This is probably pretty simple but I wanted to add custom columns for revenue between dates. I'm trying to add a columns that show me the next 3 months of revenue and the same period in the prior year. So 6 columns total.

For instance; let's say the current month I'm refreshing this query is January (would be nice if this field was defined or easily changed). So there would be a custom column if the "Launch Month" and "End Date" are between February then the column would be (Revenue/Term) and if not then zero. Then there would another column for March, April, prior year, etc.

https://preview.redd.it/oq69vsfk3ehe1.png?width=654&format=png&auto=webp&s=a098f06485bef2f29335304b46c70112650b361

I need help on something I might be over complicating. I have a power query that holds a significant amount of contract data. What I want to do is take prospective pipeline data and compare the power query of contract data for contracts that were present in the previous calendar year (PY), the trailing twelve months (TTM), and what is currently under contract at the given date.

Normally this is something easy but the start and end dates can vary greatly so I can't just say "StartDate"<Report Date for instance.

Top table in the photo is a mock up of the power query.

I have a large excel data table that has a unique ID for each customer. What I’m trying to do is write a formula that can check if this ID is elsewhere in the data and is also between two dates.

This table is also then utilized in a Power Query as well there’s a solution there.

The other day I got fitted at Club Champion and while I thought the whole thing was a terrible experience I did at least settle on shafts and heads I want. Issue is it’s not like these shafts come standard in the Callaway or Taylormade heads I want.

For those of you that have gotten fitted but decided to purchase elsewhere where did you go? Just finding a place to purchase heads only seems impossible.