Forum

Hi Dixon, Welcome to our forum! It's not so much that the format is using the clause from the format above, but rather the conditional format th...

My pleasure, Aslihan 🙂

Thanks for sharing your file. You can use this formula: =SEQUENCE(1,40,MIN(E10:E1000)+Workings!K4*0.0416666666666667,0.0416666666666667) W...

Hi Ian, We have to remove the mark complete flags in the back end. Please email a list of the session numbers and we'll do it for you. BTW, this is ...

Hi Robb, Have you see this tutorial on numbering grouped data in Power Query? Mynda

Hi Aslihan, Welcome to our forum! As I explained on YouTube, please provide a sample file so we can see what data you're working with in the PivotT...

Hi Eduardo, Thanks for sharing your files. The most I'm seeing is 3 decimal places. In cells D20 and E20 of your Artigos.pdf.xls file there are the...

You could try using VBA to programatically open the file, refresh, save and close so your colleagues always have up to date data.

Hi Eduardo, You should set the data type to Decimal Number. If you're still stuck, please provide an extract of your data in the csv file and let u...

Hi Frank, You can't calculate CAGR in a calculated field because you need to be able to dynamically determine how many periods in the data and then...

Hi Peter, Turns out you can't refresh queries in Excel Online yet! You will have to open the file in the desktop to get updates, sorry. If I hear b...

Hi Christoph, It is far more efficient for Power Query to connect to .xlsx files than it is for .xlsb files. I wonder if your file is large. If so,...

Hi Peter, If you have the SharePoint credentials window asking for how you want to connect to the source data then that implies that the data is n...

Thanks for clarifying. It sounds like you have calculations set to manual. Go to the Formula tab > Calculation Options > make sure it's set to A...

There's no quick way to create a new query for each column. You can either create one query, apply the steps, then copy that query and edit the column...