Forum

Hi Junko, No images attached. Can you please upload them again. Be sure to click the yellow 'start upload' button. Thanks, Mynda

Hi Luna, You can 'Protect Workbook' to prevent access to the Query Editor, however they can still Refresh the query if they know how. Does it ma...

Hi, This tutorial covers counting coloured cells: Mynda

Hi Shantanu, There's not enough information to help you. 1. Is this for a single period (day/week/month/year). 2. How is the measure written?...

Hi Kevin, That's quite a conundrum! Please see solution attached which uses an INDEX MATCH array formula of sorts: =IF(OR(G5=0,H5=""),0,INDEX($G...

Hi Junko, Importing data from a SQL database is not really much different to importing from an Access database, so I personally wouldn't bother bec...

Hi Junko, By default Excel will format Tables in blue and Power Query tables in green. However, you can override these defaults so this is not alwa...

Hi Stephen, You can use the DateTimeZone.SwitchZone function. BTW, I've moved this question to our Power Query Course Members forum. Please post t...

Yes, replace. You're changing the type setting, so you might as well replace it. Assuming you haven't applied any steps that require it to be the orig...

Hi Kris, Your file didn't upload properly. Can you try uploading it again, please. Mynda

Correct. It's a calculation, so I'm not sure why you don't want it there. If you don't want it in the values area then you'd have to do this calculati...

Thanks, Bob. I would split this data into two tables: 1. A Dimension table that contains the first 6 columns from ConstID to CountryName. You ca...

Hi Karla, Is it possible that you'll have an account number with multiple DC dates, or only ever one? If the latter then you can duplicate this que...

Hi Kathy, Depending on how your data is structured, you can add a calculated field or calculated item to the PivotTable. You can then format that f...

Hi Bob, Your file didn't get attached. Can you try again please? Mynda