Forum

Sorry, Vanessa. I forgot when you want to keep columns other than just the Binary content you need to follow a process similar to importing Excel f...

Hi Vanessa, No file was attached. You have to click the 'start upload' button to actually complete the upload. Mynda

Hi Vanessa, The filename column should be there before you expand. Can you please share a sample of your data so we can give you a sample solution ...

Hi Vanessa, Just make sure the 'Name' column is not one of the 'Remove Other Columns' before you click on the double down arrow to expand the binar...

Hi Marianne, I'm glad you found your way to the correct forum group for members. I've deleted your other post. It can be tricky creating a P&...

Great. Glad you're on the right track now.

Or maybe it's a 2010/2016 issue. I tested in 2013. Unlikely though. Mynda

Hi Peter, Thanks for sharing the file and screen shots. I think there are still some pieces missing from the puzzle, but I've created some KPI's in...

Hi Peter, It'd be ideal if you can create a sample file containing some data or dummy data that mimics the structure of your model. At the moment I...

Hi Steve, It sounds like Excel doesn't like when you do that. I tested it using the session 5 form control chart & buttons and didn't have a pr...

Hi David, The forum will show the posts in descending order based on the most recent post or reply. If the one at the top was from 3 weeks ago then...

Hi Martin, This formula will round up: =(YEAR([Date2])-YEAR([Date1]))*12+MONTH([Date2])-MONTH([Date1]) And this will round down: =IF(DAY([...

Hi Calla, Glad you settled on Power Query. That would have been my recommendation if Consolidate didn't work. Mynda

Hi David, Great to have you use the forum. Please tell me which menu you used, because there isn't one called 'From a Workbook' so I can't tell ...

Glad I could help, Greg.