Forum

Hi Tim, The formula below will exclude text containing vac and stump based on the data you pasted into your question and pasted to cell A2: =FIL...

The short answer is, no! If you delete the files from the original folder and then refresh the query it will also remove the data from the model. The ...

Hi Bax, You can pivot the Address Field column with the Details column containing the 'Value'. In the Advanced options choose 'don't aggregate'. ...

Hi Danielle, First, you should remove the "Columns=39," from the source line to allow for variable number of columns. At the moment it will only ev...

If you have Microsoft 365 then I'd say you could write a recursive lambda to combine those formulas into one. Not my area of expertise, sorry. Maybe s...

Hi Paul, I've moved this thread to our Power Query course members forum so that I don't miss it again. Once you load your data to the data model...

Hi Danielle, You can certainly use the formula approach. In the file attached you'll see I've added a column by referencing the State table, which ...

Hi Andrew, You can add a condition to the formulas that build the data for your chart that hides it if a control cell meets the specified criteria....

I'd like to suggest another option. First, the timestamp in your dataset is text and needs to be converted to a proper date time serial number before ...

Please upload a sample Excel file. It's very difficult to imagine the scenario you describe in my head. Thanks, Mynda

Hi Navoda, Welcome to our forum. calculating times between a start and end time on different dates is explained in this post under the heading "Shi...

Hi John, Absolutely nothing to worry about with regards to loss of functionality with VBA or anything else. Embrace the upgrade and enjoy all the n...

Hi Kyle, Thanks for sharing your file. The chart you have in there isn't a stacked column chart, which is why it won't allow you the flexibility to...

Hi Sanjeet, Welcome to our forum! I assume you're referring to the chat on the sheet called 'Gantt Chart'. If so, there's no easy way to apply a...

Hi Tim, Great questions. It is more efficient to remove date fields other than the day from your fact table and instead store them in a calenda...