Forum

Hi Claudine, That's easy: Add a Custom Column with the following formula where Text1's column is called 'Column1' etc. = [Column1] = [Column2] ...

Hi Vivian, It was lesson 4.03. In future it would help if you can remind me as I have hundreds of videos and my memory isn't that good 🙂 It so...

Hi Vivian, Which lesson are you referring to? Mynda

Hi Adam, That sure is confusing! I can't think of a more efficient process, but you might like to refer to this post: how to improve Power Query re...

Hi Vivian, You can only paste new data to an existing table that was originally created from pasting the data. i.e. if the data source is a Table i...

Hi Cheryl, Just type over the 'Auto' text in the 'Value Decimal Places' field with 0 and press enter. Mynda

Hi Alaster, The course files are available from the course home page here. There is a link at the top under where it says the course duration. P...

Hi Adam, The second attachment isn't attached 🙂 Can you please try again? You need to click the yellow 'Start Upload' button to actually upload t...

Hi Michael, Welcome to our forum! This IFS formula is the equivalent of an approximate match VLOOKUP and I wrote a tutorial on replicating an ap...

Hi Vivian, By marking a table as the 'Date Table' you're enabling the use of the DAX Time Intelligence functions and preventing Power Pivot from cr...

Hi Trevor, Please see session 7.03 and 7.04 of the Power Query course on dynamic folder and file paths. Mynda

Hmmm, because the documents that don't have 'Project' at the end don't have a space after the project code. Why don't you split the Project... off the...

Hi Mohammed, See session 10 of the Power Pivot course for time intelligence functions. 10.02 PREVIOUSYEAR or 10.08 PARALLELPERIOD. Kind regards,...

Hi Andrea, Welcome to our forum! It's difficult to work with your data because it's not consistently formatted. I would use Power Query's Column...

Hi Chris, There are some suggestions here. Mynda