Forum

Hi William, You can just add the cells together and then use a custom number format to display the cumulative time i.e. [h]:mm More on formattin...

Hi Anne, Sounds fine. I would only load the QuickBooks data into the worksheet if you absolutely need it there. Otherwise leave as connection only,...

Hi Chong, Unfortunately you can't group the times into intervals using the PivotTable Group setting. If you want to filter by time intervals the...

Hi Ann, That should give you the correct results. He's my sample file that works. It might help you troubleshoot. If not, please send your Excel...

Well done, Mardi! Glad you figured it out yourself 🙂

🙂 only you can make yourself look like a BI hero, I simply encourage and point you in the right direction. You have to put in the hard work 🙂

Hi Mark, That's a Report Page tooltip. The feature is still in Preview so you have to enable it in the Options for Power BI Desktop. Mynda

Hi Anne, Great to hear you're reaping huge rewards with Power Query. Spread the word. It's surprising how many people still aren't using it. Now...

Hi Mitul, The original formula in the file was missing parentheses. If you replace it with the one I mentioned above i.e. this one: =SUMPRODUCT(...

Hi Mitul, 1.1 You can learn SUMPRODUCT here 1.2 You can use TRIM to remove leading and trailing spaces: TRIM 2. The formula does include both...

Hi Vicente, Yes, you can change the load settings in the Query pane on the right-hand side of the Excel window. Select the query > right-click &...

Hi Mitul, You can use SUMPRODUCT, but your source data is a mess. i.e. some "Excel" Book strings have leading spaces and others don't. Likewise for...

Hi Mark, The data type needs to be set at the table containing the URL, not the measure. So, yes adding the image URLs to their own table may work/w...

Hi Dave, You can share your files but those users on Home and Business will not be able to make any changes to the Power Pivot PivotTables i.e. no ...

Hi Mark, Yes, good point, we must be patient with Power BI and appreciate what we have, not what we haven't 🙂 Try FORMAT(-1263807.08, "£#,,.00...