Forum

Hi Chan, Thanks for sharing your file. My only concern is that as you have a column with a date header I suspect you will either be creating more w...

Hi Dilan, Welcome to our forum! One option is to duplicate the query: in the first query keep the rows that have null in the End Date column and...

Hi Philip, Welcome to our forum. I'm trying to visualise the issue, but it's quite difficult to follow without your Excel file or even screenshots....

Hi Sabarish, Welcome to our forum! When I open your file the Gantt bar is starting from the same date as the Start date.. See image attached. ...

Hi Andrea, I'd put the 'data table' information in the Excel worksheet and just align the cells and chart so they appear to be part of the chart. Y...

Hi Zac, The delimiter argument is optional, so you could just leave it out. That said, if the purpose of adding this column is to detect what the l...

Hi Cheryl, You need to remove the page level filter if you want one visual filtered differently, but you don't need to add a slicer to filter the o...

Hi Zac, Welcome to our forum! It's great to hear you're making use of your Power Pivot skills 🙂 Your formula looks like the last comma is in t...

Hi Jim, You can use List.Min in a Custom Column for this. I can't reference the screenshot because it's too small and therefore unreadable, but it ...

Hi Matt, Phil is right. Let's assume you want to bring the 8 tab delimited files into 8 separate sheets in a single workbook then you need to creat...

Please start a new topic and upload an Excel file with a sample of the problem data. There are probably some non-printing characters in the data that ...

Hi Peter, The idea is that the user doesn't double click to drill down. The chart is already drilled down and they simply select the item from the ...

Hi Yvonne, Welcome to our forum! Please attach a sample Excel file so we can see the whole picture of your formula and how it relates to the worksh...

Hi Ajay, Welcome to our forum! I'm not sure if that feature is available in all versions of Excel as an update, but I'd recommend updating your ver...

Hi Jim, I'd remove the D. from each value using Replace. Then format M through F columns as a number data type. This way you can use the Group By t...