Forum Discussion
Inventory Analysis- Average Weekly Sales
Hello all! I am relatively new to PowerBI and had a couple of questions. I am doing an inventory analysis where i have to do the following : Calculate average weekly sales. I have created a fi...
To make time-based calculations easy you have to structure your data correctly in the first place. The model should have a proper calendar, first of all, and it should follow the star schema. If you do it the right way, you'll have a much easier time calculating what you want. Please learn about the star schema and its importance for Power BI modeling: https://docs.microsoft.com/en-us/power-bi/guidance/star-schema