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 🙂
Community Championmpbems The slicers will come automatically - see this file and let me know if it's what you want.
AllisonKennedy this is great! I think I need to revise how my data is collected, since that is probably making this more difficult than it should be.
This is how my data is currently recorded:
Instead of submitting their schedules in one line, I'm going to separate them out so it's one entry per day of week and then I should be able to get the results I'm looking for. Thank you!
- AllisonKennedy
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 🙂
Wow is all I can say...I'm looking at the applied steps and there's no way I would've been able to figure all that out...thank you again!
I ended up rewriting my collection method in PowerApps to match the format you provided, but I may keep both until I can (hopefully) figure out the applied steps on my own. Thank you again!
AllisonKennedy one last thing - sorry to be a pain! In the sample file, when I select the first week (2/12/23 - 2/18/23) it only shows Monday/Tuesday/Thursday since that's where the matching data is found. Is there a way to always show the Sunday through Saturday columns, and a blank field when there is no match?
- AllisonKennedy
mpbems In the sample file that's possible because it's using a dimension table for the days of the week - just click 'show items with no data' in the visualizations pane
If you don't have a dimension table for days of the week and are just pulling it from your one table, that won't work. Dimension tables are key! 🙂