Forum

Hi David, Are you able to share your Excel file? You can anonymize the data if it's sensitive. Mynda

Hi Michelle, There was no zip file attached. However, if you get files from a folder then you make your transformations in the 'Sample' query as ex...

Hi Matthias, I'm a bit confused by your question. You can't select every single value in the list in parameter editing, you can only select one. ...

Hi Alison, You don't need to use FILTER because CALCULATE's arguments are filters. You should be able to write your measure like this: Tot.Contr...

Hi Patricia, I'll contact you via email to discuss your options for Excel consulting. Mynda

Hi Svea, To do this using formulas would be unwieldy and error prone. I don't recommend it. Instead I would use a PivotTable for this. In the attac...

Hi Svea, Is this the same question as this one: Mynda

Hi Michelle, The problem with the text file is that it is delimited by a space but it has several consecutive spaces. In Excel we can tell it to 't...

Hi Patricia, I'd set up the PivotTable and then insert the Pivot Chart for it and make sure it's going to suit your dashboard needs. Then move on t...

Hi Sophie, Thanks for sharing your example file. It makes it much quicker and easier to provide you with a clear answer. You need to set up dyna...

Hi Hughes, I think I'm missing some details on the process you have followed. You might be able to fix your existing query by adding a step befo...

Hi Anne, I'd put the Actual Hours for the user to input in a separate table and then merge that table with your Target Hours table. Then you can do...

Hi Paul, Yes, I think so (caveat is because I haven't seen a sample file). You can Pivot the data in Power Query. You'll probably need to add an In...

Hi Alison, You can't hide the visual, but you can hide the results using a solution as described here:/a> Mynda

Hi Hughes, You can reference the columns by position. There is an example in this forum Q&A. Note: Power Query is zero based so the first colum...