Setup data model which allows to interact easily

No worries. I’m actually working on a stock report today.

Make sure you have a date table in your report, link below to the best date table around.

Extended Date Table (Power Query M function) - DAX / M Code Showcase - Enterprise DNA Forum

Also, create a dimension table for your site storage capacities. Ask yourself the question if these capacities will change over time or are they fixed? If they change over time you will need to create what is called a Slowly Changing Dimension table.

Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

Probably create a dimension table for your Brands too.

2 Likes