Forum

Hi Aye, I recommend this VBA course. Mynda

Hi Shantanu, You can add a column to your data table with the DAX FORMAT function. It works just like the TEXT function in Excel. e.g. =FORMAT([...

Hi Ali, Is it absolutely necessary for this data to be spread across multiple sheets in the first place? This is why you're having problems. It's d...

Hi Alison, I've moved this thread to the open Power Pivot forum as this is outside the scope of the course and I don't currently have time to under...

Hi Luna, The toggle button images are in the folder 'Practice Files After'. The file names begin with 4.20_...png Mynda

Hi Sylvain, Welcome to our forum! I'm not clear on what your desired result is and what data you have to work with? Are you trying to identify t...

Assuming it's just a regular table you can add a measure to the 'Values' area that calculates the % of Occupied Beds. Mynda

Hi R, Unfortunately you weren't clear and as there was no table or sheet labelled 'desired result' I incorrectly made the assumption that the sheet...

Yes, I agree that this is the likely culprit, Cedric.

Hi Sarah, Thanks for the updated file. It's always best to cover all scenarios otherwise we're both wasting our time. In the attached file I've ...

Hi Cedric, It's difficult to say without seeing the file. When you change a column name you must do it at the last step in case it is referred to e...

Hi R, Thanks for the file. Please see solution attached - the final query 'Merge1' matches your desired result. Mynda

Hi Sarah, Please see example attached. Mynda

Hi Matt, Slicers don't work like that. You have to be able to select any item in the Slicer. The only way you can hide items that are filtered out ...

Hi Aye, Sorry for the slow reply to this. I've looked at it several times and I'm not clear on what you're trying to achieve. Can you please upload...