Forum

Hi Jim, Because your dataset has duplicate column names, Power Query renames the duplicates 'First_Name_2', 'First_Name_3' and so on. It looks like...

Hi Loren, Glad you found a solution. The problem you had is different to Matthew's. Your issue was that the dates were incorrectly stored as text, ...

Hi Mukesh, Because you're enclosing the results you want in "", you are treating everything between the "" as text. To get the function to work re...

Hi Michelle, The table containing the diesel prices is not related to any other table in the model. If you create a relationship between the Diesel...

Hmmm, if you have a separate column for each course name then your data is not in the correct tabular layout for Power Pivot/PivotTables. Maybe that's...

Hi Vivian, It should be fairly straight forward. Using Power Query, extract a list of distinct client names from your fact table. This table will b...

Hi Amaro, It's difficult to help without seeing your file. However, the most important thing is that your data is stored in a tabular layout. If yo...

Hi Christoph, The file will only refresh when it's open. In which case you might be best to set it to refresh upon opening. Mynda

Hi Vivian, Create a dimension table that maps the clients to their respective groups e.g. Client Group A A B B C ...

Hi Valerie, I know I cover this in the Power Pivot course in the CUBE functions lessons for Excel. In Power BI a Slicer is just another filter, so ...

Hi Jim, Yes, the course is enough to do what you want. I have copied you on an email to another consultant. Be aware they charge more than the prev...

Hi Michelle, Are you able to share your file so I can see the data structure. Please also give me an example of the calculation you want to perform...

Hi Dave, If you prefer to do this in Power Query then you can split the date into month and year columns, then join them back together in a custom ...

Hi Joachim, Alan and I had the same idea. My PivotTable also has subtotals. Mynda

Hi Julie, It sounds like you're selecting multiple cells containing the dates before you right-click. You only need to select one date cell, then r...