Forum

Hi Bax, You can either use Power Query to combine the 3 tables into one table and load that to Power Pivot, or you can create dimension tables for ...

Hi Johnson, Welcome to our forum. The total is taking the sum of the daily rate x the sum of the working days, rather than the sum of the normal ra...

My guess is the rngTypes named formula is causing the problem, specifically the reference to array CompLog[@] Mynda

Hi Lisa, Welcome to our forum! The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey ...

Hi Jessica, Great to hear you're getting a lot out of the courses You can either format the start of quarter date in Excel to only display the ...

Hi Kevin, Great to hear you found my videos helpful Thanks for sharing your file. If you look at the value in the Rekeningnr column you'll see ...

If that doesn't work, then I'd say the answer is no as I'm not aware of any other language or locale settings in Excel.

Hi Oscar, Thanks for sharing your file. Your dates are not the correct format. They're text and they need to be date serial numbers. You can use th...

Hi Louis, Whether the user entered information is in the current workbook or an external source wouldn't make any difference to the refresh process...

Hi David, It doesn't like the Parent list being in a Table. If you convert this to regular cells and rename it 'Parent' as you'll lose the name whe...

Hi Lea, Have you tried changing the language settings in Excel via the File tab > Options > Language? Mynda

Hi Conny, Welcome to our forum! It's great to hear you found my tutorial helpful. What you have in your Power Pivot model are 3 fact tables. If ...

Hi Jesus, Thanks for sharing your file. I can see it is not in the correct tabular layout. You need to use Power Query to unpivot the 'h' columns i...

Hi Oscar, Welcome to our forum! Please share your file so we can see what might be causing the problem. Mynda

Hi Jesus, The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the fi...