Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am looking at a day by day view of how many stores are open, their total sales, and what the average per store is in sales. I would want the week total to be different. The average per store would add up all the averages for the week and then the stores open is total sales divided by the average for the week. I made an excel with what I am looking for a formulas for excel would be. I need some help with formulas for the week end data.
Solved! Go to Solution.
Nevermind I got it working with
The first formula doesn't help me get to the $17,624 because I dont have # of stores for the total of the week. I need to add up the averages for each day of the week.
@Anonymous - Could you share your pbix?
Unfortantely my file is full of sensitive data. I really just need a measure that can add up a daily value for the whole week. So if I have average sales on a daily level, what is the total of 7 of them each week.
Nevermind I got it working with
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
79 | |
62 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
99 | |
73 | |
65 |