Forum

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...

Hi William, I'm a bit confused by your description. Each query links to a single data source and then puts the final query result either into anoth...

Hi Claudine, No file attached. Be sure to click 'start upload' and wait for the grey check mark beside the file size before clicking submit. Myn...

Hi Paul, Not sure there's a better way to isolate cell G4 that what you've probably already done. When you 'close and load' choose Connection On...

Hi Claudine, You have two tables in your model with the same names: one called Group Settings and another called Group_Settings. Your PivotTable is...

Hi Paul, Create a new query to get the data from cell G4, then add a column to the original query =#"New Query Name" Mynda

Hi Laura, Welcome to our forum! Your merge query will be triggering all the individual queries to make another call to the website, as explained he...