Forum

Hi James, If you put 0:1:00 in a cell and 0:1:30 in another cell then divide the former by the latter, you get 0.667. What have you tried that h...

Hi James, Can you give an example and the expected result please? You can't divide 'times' as such. What is 12.30am divided by 3.45pm? Makes n...

Hi Brenda, Nothing is attached. After you select the file you need to click Start upload to load it to the site. Phil

Hi Ivan, Nothing is attached. After you select the file click Start Upload to upload it. Phil

Hi Dixon, The video you linked to is about Power Pivot so I'm not following how that relates to your query about Power View. Sorry I don't have 48...

Hi, Please be specific (give an example) about what type of 'button' you mean and in what context. Regards Phil

Hi Celeste, No Power Query can't do that. VBA can, is VBA a viable solution for you? Regards Phil

Hi Jeroen, In your Excel workbook the logic you are using to determine the type of the meal doesn't make sense. According to the workbook the type...

Hi Ben, Without the actual data I'm guessing as to what your data is. If you had dates in your table, you could do this with time intelligence fun...

Hi Felix, You can download the CSV files from here Power Query Get Files from a Folder Regards Phil

Hi Tom, Do you mean coverage by us? We'll probably look at covering Office Scripts but not sure about Power Automate. The difference is Office Sc...

Hi Tom, This forum isn't for Power Automate, afraid we can't help. Try posting your problem here Microsoft Power Automate Community - Power Plat...

No worries.

=if List.PositionOf( Module [Charge Type],[Charge Type] ) = -1 then "N/A" else List.PositionOf( Module [Charge Type],[Charge Type] )

Hi Mohamed, I can't reproduce your issue. If you have the data as text in Power Query then when you load it to Excel it should still be text. A...