Forum

Hi Julian, Have you tried this before? It only asks you for the password the first time you try. If you need to edit the email and or password this...

Hi Rita, It's great to have you join my course. The download links are made available on your My Profile page 31 days after you join. This is to...

Hi Julian, It also needs your password as explained here. Mynda

Hi Mitul, Your PivotTable is referencing data in this workbook: Getpivotdata-from-ExcelFunctions.net_Rearranged DATED THU. MAY 24, 2018.xlsx!Tab...

Hi Crystal, You need to write a measure for this, as explained here. Note: there are different approaches required for columns from the same table ...

Hi Teddy, I'm not sure what your definition of a dynamic control chart is, but you can use Pivot Charts and Slicers to dynamically filter the view ...

Hi Anne, Not sure what you mean by 'The expanded option is not available...'/ Anyway, to get the latest dates create a copy of the first query a...

Hi Harry, There is no supported connector for Cognos yet, but this post has some pointers that might help: Mynda

Hi Anne, You were on the right track with the grouping. See attached. Mynda

Hi Tim, Have you tried changing the Data Type to 'Duration' for the Login Time column? I did that and it returned the time 0.00:51:34 etc. as shown...

Is the Date field set as Data Type: Date on the modeling tab? Mynda

Hi Moshe, There is a new feature in Power BI that allows you to create a 'Quick Measure'. For this to work you need to have a proper date field in ...

Hi Dave, It's not really something you could completely automate with Power Query, but you could certainly use it. For example; write a query that ...

Hi Mai, Jon Peltier has a tutorial on how to build the Marimekko chart in Excel. Then you just need to use the Camera tool to rotate it. Mynda

Hi Mai, VBA won't build your chart either. It's not an automation issue, which is what VBA does, it's a Excel chart limitation. You simply can't ma...