Forum

Hi Alicia, I just listed to 5.04 and I don't mention avoiding using ODBC connections...are you sure it was this lesson? Mynda

Hi Heoun, Welcome to our forum! Power Query/Power BI require the table names to be unique. It will append numbers to any duplicate table names a...

I teach that method in my Power Pivot lessons because this is a standalone course (i.e. doesn't cover Power Query). However, the best/recommended way ...

Hi Ian, You should be fine to cut and paste or select the column and left click and drag holding the SHIFT key to insert the column in its new loca...

Hi Martin, Welcome to our forum! Ideally, you should be using Power Query to import your data to Power Pivot. I trust you won't have any issues ...

Hi Michael, You and each of the customers accessing the reports would need a Power BI Pro license (which is US$10/month), so that you can use the R...

Hi Sheralee, Welcome to our forum. I can't tell much from the screenshot, but it looks like the PivotTable may be already returning the results ...

Hi Michael, Welcome to our forum! Power BI is the tool designed for sharing specific data with different users as you describe above. The only a...

Hi Anita, Answers to your bullet points below: There are 6 channels (column B). 3 for AC load net and 3 for PV site net. The data needs to b...

Hi Alicia, From what you describe above, you're on the right track. However, you shouldn't be splitting the transaction data up into separate queri...

My bad, Mohamad. I misread your question...it was early! You can copy cells in Excel and then go to Word and right-click > paste as link. By def...

Hi James, Glad we could help. Yes, please start a new post with this question. I will be away for the rest of the week, so don't address it to me s...

Hi Mohamed, If you insert these descriptions in the Excel cell Comments/Notes, you can print them (to PDF) by selecting the setting in the Page Set...

Hi Jennifer, I think you need to add another column to your Youth Age table that converts their age based on the first incident of the month. You c...

Hi Kevin, You can use this formula: =INDEX(T,COLUMNS($A:A),COLUMNS($A:A)) Mynda