Forum

Hi Paul, Welcome to our forum! The file is in the 'Practice Files Before' folder and it's called pbi_1.03_website_traffic_odb.xlsx. Mynda

Hi Bruno, It's not possible with PivotCharts, sorry. Mynda

Hi Jim, Haven't we already answered this question above? Mynda

Hi Frans, Thanks for suggesting the workaround. This is similar to what we do in Power Pivot. It comes with the overhead of extra columns of data, ...

Hi Claudine, The problem you see in file 2 is that Excel can't display negative dates and or times, there's no such thing, therefore it returns an ...

If you can export them, then the answer is yes. If it looks different then that's not a licencing issue, it's simply a limitation. If you want a matri...

Sorry, I mistook you for one of my course members. The formula for the custom column is already stated above. You add the custom column to the tabl...

Hi Chris, Watch session 7.08 on expanding rows. You need to do the same thing except you simply convert your Dates table (called Source) to a List ...

Hi Mike, Welcome to our forum! You have two things going on here, first you have an index number which is displayed in your first 4 tables. It's no...

Hi Claudine, You need to split the column into the separate date time parts so you can join it together again using the Date.From function e.g.: ...

The function for getting CSV files is different to Excel files so you can't mix and match. You'd have to duplicate the query and change the function f...

Hi Rachael, Open the advanced editor for the Transform File query. Here you will see the Source = Csv.Document function has a parameter that specif...

Hi Paul, You need to unpivot the data so it's in a tabular format to work with these functions. They are not designed to work with non-continuous ...

Hi Declan, I moved this post to the Power Pivot course members group so that it gets priority over the open Power Pivot group. You need to unpiv...

Hi Jim, When you group dates using the PivotTable grouping tool you can't choose the date format, sorry. Mynda