Forum

Hi Sayeed, Your question isn't clear, sorry. I don't see anything called 'green water footprint' and I'm not following the flow of data from where ...

Hi Sayeed, Your file didn't get attached. You need to click the yellow 'start upload' button after selecting your file and then wait for the grey c...

Nothing attached, Jim. Please click the 'Start' button after selecting the file and wait for the grey check mark beside the file size before clicking ...

Hi Michael, The units table sounds like it's a fact table, not a dimension table. I recommend you create a proper dimension table for the accounts ...

Sorry, Sally, but I need the source data in an Excel file, please. If it's sensitive data, you can strip out everything but the x axis labels and the ...

Hi Sally, Can you please upload an example Excel/Power BI file. My brain stopped visualising your description after the first sentence! Thanks, ...

Hi Richard, I would say that unless you're having performance issues with your data structured the way it currently is, or you're unable to perform...

Not sure what you did wrong, but it works for me. See attached. Mynda

Hi Malcolm, Welcome to our forum! It's hard to say the cause, but I'd start by running a repair on Excel/Office. I'm assuming of course that you've...

Not sure, Jim. I'm a bit confused as to what "Section1/" in the error is referring to. I'm wondering if something has a forward slash in a name. If so...

Hi Ayal, You can use the technique in this tutorial: Excel Sorted Dynamic Unique List. Note: you cannot put a formula in the Data Validation dia...

Hi Erik, It's difficult to say without seeing the file and desired output, but you might find some helpful ideas you can use in this Excel Project ...

Yes, you'd have to write a measure that checks if the current date (filtered or row label in the PivotTable) is within the employee's start and termin...

Hi Sarfraz, In that case you can ask Power Query to match 3 columns. See example attached. Mynda

Hi Sarfraz, All example dashboards (other than those in my Excel Dashboard course) that I have built are already available to download for free fro...