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