Forum

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...

Hi Graham, Welcome to our forum! You can use the following formula to convert the date serial numbers to text and then back to a number: =VALUE(...

Hi Cam, A PivotTable would give you a layout like this: Project 2022 2023 Katroc Jan 13, 2022 Sevron March 12, 2022 ...

Hi Howard, Thanks for clarifying. Another question: The closing balance doesn't look right to me because it doesn't reconcile to any of the numb...