Forum Discussion
Solved
Help creating table for creating correct data layout for Power Pivot - Am I missing something?!
I'm relatively new to PowerPivot and Pivot Tables so I'm sure I'm making some rookie error here but can't find an uncomplicated or clumsy way of doing this... I have a set of Data. It includes th...
Screenshots work only if you're asking help on formula syntax or to ask someone to check why a formula seem to be not working.
You are asking for assistance in regard to power pivot more complicated. If you want to keep your problem a secret that's up to you, people on here do not like to try to solve puzzles especially complicated ones with just a screenshot because it becomes frustrating and time consuming and lots of back and forth questions etc etc etc. Please share your dataset.
I appreciate that but the dataset is loaded with confidential data; I’d likely lose my job if that were available to the public… With respect, I think that the screenshot adequately illustrates the format and layout of the data; the data itself should t really be necessary to see the problem (or my error).
See attached for sample data model with slicer
also here's a tutorial about Power Pivot and DAX formulas:
https://youtu.be/e-CFYi52gpc