Forum

I tested it on my PC. When you follow the steps in that video, one of the columns contains the file path. This file path contains the folder name. All...

Hi Bill, Welcome to our forum! Unfortunately, Excel 2013 does not have the newer options to load to PivotTable and Pivot Chart. There's no way t...

Hi David, Welcome to our forum! First, you should always use Power Query to get the data from your SQL database and then load it to Power Pivot/...

Hi Patrick, Please see this tutorial on grouped running totals in Power Query. Hope that points you in the right direction. Mynda

Hi Paul, Using From File > From Folder and after you choose Transform Data normally you would click on the double down arrow on the content colu...

Hi Shelley, There is a similar question here that has been answered in the Microsoft Power BI forum that gives some options for solving this. My...

Hi Garth, Please try uploading the file again. Be sure to click the Start Upload button after selecting your file and then wait for the grey check ...

Thanks for the files. You cannot insert a slicer for a regular chart. Slicers only work with PivotTables and Pivot Charts. In my completed file for le...

Hi MC, Load the table containing the bonus value to Power Query, then drill down to the bonus cell: select the cell > right-click > drill dow...

Hi Bax, You can modify your added column formulas like so: = Table.AddColumn(#"Added Conditional Column7", "PO < " & Text.From(HourBand1)...

Hi LaDonna, Welcome to our forum! Your file didn't attach. Please try uploading again. Be sure to click the 'start upload' button after selecting y...

Hi Rick, There's no specific tutorial on loading JSON files, but there is a JSON connector in the Get Data > From File > From JSON in the Pow...

You can't put a measure in the filter field. If you want a filter that is 'current month' then you'd have to add a column to your source table that cl...

Typically you will use the filter in the value field measures e.g. CALCULATE(expression, filter) If this doesn't work for you, please provide a sam...

Hi Claudine, I'm not sure I understood the requirement, but please see if the measures Puprose >1 and Purpose Blank in the attached file are cor...