Forum

Hi Mohammed, It looks like PBI is internally rounding up the minutes value before calculating the minutes and seconds for its durations. This is t...

Hi Michael, Best to include all worksheets (tabs) in the files. The error may have something to do with the sheets/sheet names not being consisten...

Hi Michael, There's no picture attached. This error usually indicates that a column or sheet is missing, or named something other than the query...

Hi Peter, To trap errors in PQ use try .. otherwise. Here's an example where I call the List.Sum() function but don't pass in a list let Source...

Hi Mazharul, That CSV contains no data, just column names. Regards Phil

Hi Danielle, You need to create a composite column made up of the Model & State which will give you values like AGF535VCSA, AGG503VCXQNSW etc ...

Hi, Can you please attach your query so that I can investigate. Regards Phil

Hi Tina, You've posted in the Power Query forum and I assumed that's what you were using even though you mentioned Microsoft Query. MS Query is ...

Hi Tina, Please supply the file with the query so we can examine it. Regards Phil

No worries.

Hi Patrick, No file attached. regards Phil

Hi Andy, Please supply a file with a question so we don't have to recreate everything. See attached file for solution. I'm not following the...

Hi Chris, Yes, always best to include all scenarios 🙂 I just needed to make an adjustment to the loop counter in the function to this each [...

Hi Alexandra, no file attached. make sure you click Start Upload after selecting the file. regards Phil

Hi Peter, When you get an error that states aa key is missing it usually refers to a missing column, or a column that has been renamed, or a missin...