Forum

Hi Deepak, Please provide a small sample file that illustrates your data and desired result so we can help you further. Mynda

Hi Frederic, Not really. However, that's not to say Excel can't do what you want. It depends on why you think you need a dynamic cell name. Perhaps...

@Mamie, I see. I misunderstood your question. Glad you got it working. @Steve, explicit measures are ideal when you need to write further DAX measu...

Hi Mamie, Thanks for sharing your file. You can use the implicit measures already built into PivotTables for these calculations. That is, build a P...

Hi Mamie, I couldn't open the privnote and the screenshots don't tell the story enough for me to help. Please create a dummy/mockup file containing...

Hi Mamie, Welcome to our forum! We'd need to see your file or a mockup of your file, or at a minimum, screenshots so we can understand the filter c...

Hi David, Please see the file attached. I used a simplified version of your sample data just to make it easier to follow. I hope that's what you we...

Wow, so pleased you enjoyed my course, Steve! Hope you enjoy Power Query as much 🙂

Hi David, You didn't mention the date dimension, so I didn't allow for that. Please provide a mockup of your desired result based on your sample da...

Hi Thulasi, You can and should be using Power Query to get your data and load it into Power Pivot. In Power Query you can create queries to extract...

Hi David, You can use this measure: =CALCULATE(DISTINCTCOUNT(Table1[Accounts]),FILTER('Table1','Table1'[Sales]=0)) Mynda

Hi Derek, Hmm, not as easy as you might think. You could try 3D maps. Mynda

Hi Oana, It sounds like the column chart is ideal. You can use expand and collapse buttons on a PivotChart to switch views from daily to weekly etc...

Hi Chen, Select Workspaces in the left nav > select the ellipsis (...) next to My Workspace > select Edit workspace. You'll see an option to ...

Hi Aye, The formula is referring to a name ListSheets except there is no name set up in that file, which is why you're getting an error! See this t...