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 Champion
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 🙂
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! 🙂