Forum

Resolved.

Answered on Excel Forum

Answered on Mr Excel

Hi Mohammed, That's a text column so you can't SUM it, hence the Total in the table makes no sense. You can write a measure to calculate total w...

Hi John, You've already mentioned the solution to this which is to record data in the correct, tabular format. As it is, when PQ imports data in...

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