Adam Bender
Active Member
Joined: Jun 14, 2022
Follow
RE: Conditional Merge between Dates
I've had this problem before, and I eventually concluded that there is no such thing as "between" in Power Query. There are multiple options, includi...
3 years ago
Forum
RE: Issue with slicer for data model
So, are you saying that you have multiple pivot tables that you'd like controlled by a single slicer? If so, take a look at this page.
3 years ago
Forum
RE: Tables or Named Ranges with no Query
ExcelNovice2020, I think you're probably dealing with a bigger issue than whether or not this is possible, and based on the conversation so far it doe...
3 years ago
Forum
RE: Keep rows but remove duplicates in a column
Hi David. Can you post some sample data? That would be helpful to better understand what you're looking at. I'm thinking that what you're looking f...
3 years ago
Forum
RE: Combine files in folder painfully slow
If you're using the "Combine Files" default function in PQ it's going to be slow and inflexible. I prefer to add a custom column that extracts the bi...
3 years ago
Forum