Forum Discussion
Stuck with DAX - need to replicate Excel formula
If you click 'Transform Data' in the sample file I sent through, you'll notice that I've used your current data collection format and transformed it for you, so up to you if you change the collection method or not - let me know if you still are getting stuck, otherwise hope there's a solution in one of these replies for you 🙂
Ashish_Mathur I've updated the info I shared in an earlier post. What I'm trying to do is create a visible schedule based on user input. In the example below, column A is a list of visitors and columns C through P represent locations they are scheduled to visit on a particular day. I'm looking to select a week, and a location, and view all scheduled visitors on that given day of the week.
Initially I had numbers listed but they should actually be locations.
Row 26 includes the slicers, and row 29 is the desired table layout (column headers in line 28).
Super UserHi,
Share data in a format that can be pasted in an MS Excel file.