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 🙂
Super UserHi,
Does this measure work?
Measure = selectedvalue(Data1[text1])&", "&selectedvalue(Data2[text1])
If not, then share some data (in a format the can be pasted in an MS Excel file) and show the expected result.
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).
- Ashish_Mathur
Hi,
Share data in a format that can be pasted in an MS Excel file.
