Forum

Great idea, Velouria! I never think to use Sets.

Congratulations, Gigi! Practice is key 🙂

You may need to download the latest version of Power BI to get the preview hierarchy slicer. If not, hopefully the one from the MarketPlace will do th...

You're welcome! You don't need Power BI for this, you can do everything with Excel. In regards to the merge, you may have got the tables in a differen...

Hi Gigi, Welcome to our forum. Thanks for sharing your file. It looks like the problem with your data is that it's not in a tabular format, which m...

Hi Aye, Please refer to this forum post for ideas on speeding up Power Query refresh times. Mynda

Hi Bob, The measure requires the context in the table, hence why it works when you add the Region Name to the columns. However, you're in luck beca...

Hi John, Welcome to our forum! You can use Power Query, which is free and built into Excel. This post gives step by step instructions for combi...

Hi Lea, Sorry, I should have been clearer, you can only change whether your dates are dd/mm/yyyy or mm/dd/yyyy. You can't set it with a two digit y...

Hi and welcome to our forum! Thanks for sharing your file, however I couldn't see an example of your desired result, so I'm not sure what you're tr...

Hi Lea, You can't format dates in Power Query or PivotTable row/column areas. They are fixed formats based on your region settings. Row heights ...

Hi Lea, You can try entering your credentials in the Access Web Content dialog box that comes up after you enter the URL. Choose 'Basic'. It may o...

Hi Jason, Welcome to our forum. You're so close with your formula. It should be: =IF(OR(E3="Jason",E3="June"),D3,D3/2) Mynda

Hi Nicole, Welcome to our forum! Firstly, sharing the dashboard in a web page using the WebApp has no connection to the version of Excel they ha...

Hi Bob, I can't make much sense of the screenshot because it's too small and when I make it bigger it's too blurry. I also can't see the relationsh...