Forum

Hi Kabil, Welcome to our forum. The purpose of the forum isn't to do this work for you. You would need to make an attempt at it and then if you get...

Hi Katrina, Excel currently can't work with multiple values in a cell and compare them to cells with individual values. Therefore, I would load the...

Hi Kasey, Posting in multiple forums is against all forum rules, including ours. You must declare cross posting so we know not to waste time on que...

Good question, however I'm not aware of any way to do this, Pieter.

If you're using Power Pivot in Excel or Power BI you can change the data type in the modelling side. Otherwise, you can format the values in the visua...

Great! In that case suspect you weren't using Direct Query

I'll ask Microsoft, but I suspect you can't turn this off. I'll let you know what they say. Mynda

Hi Yuan, After the source step you can apply a filter to the file name column that only imports files that meet the criteria you specify. Mynda

Hi Yuan, If you're using Direct Query then you cannot connect to any other datasets in the same model. Mynda

Hi Yuan, Just change the data type to Date. It will remove the time component. Mynda

Glad I could help Graham! It's wonderful to hear you found my videos helpful too

Ah, ok. In that case Teams has no bearing on the file's functionality since you're using it in Excel Desktop. Please see this tutorial on workbook pro...

Hi Anton, Welcome to our forum! Can you please upload your Excel file so we can see how your workbook is structured and identify where things ha...

Hi Howard, With complex conditions like this it's easier to add some helper columns when working it out. In the attached file I've added some table...

Hi Heather, Welcome to our forum! If you're using Excel embedded in Teams then you're effectively using Excel Online and you cannot execute macr...