power bi measure

[Julier]

Hello,  I am trying to show a comparison of a rcumulative running total over set months by different sites on a line chart, I have created the measure below and it does change the visual when the slicer is used but it does not separate by months and does not add the sales as the days go, i want to be able to see the 2 months side by side with the sales growing for each day for each month, and be able to use a slicer to see how each site is performing, the measure i have below doesnt total the sales as the days go on but just shows what sales where on that particular day and does not show each month, Hope this makes sense, I have had to cut down the data table so that i can post this message

I want to be able to show the data something like below

Site	Date	Day Number in Calendar Month	Volume (SQM)
Smiths	01/05/2025	20	14846
Taylors	01/05/2025	30	11153
Smiths	01/06/2025	24	22412
Taylors	01/06/2025	11	13355
Taylors	01/05/2024	23	15495
Taylors	01/05/2024	9	6728
Taylors	01/05/2024	2	8764
Taylors	01/06/2025	18	18852
Taylors	01/05/2025	5	10303
Taylors	01/05/2024	3	6147
Taylors	01/05/2024	2	3472
Taylors	01/05/2025	13	2991
Taylors	01/06/2024	5	9223
Smiths	01/06/2024	28	13091
Smiths	01/06/2025	2	4068
Taylors	01/05/2024	24	8946
Smiths	01/05/2025	9	14725
Taylors	01/05/2025	1	888
Smiths	01/05/2024	2	4934
Taylors	01/05/2024	24	0
Smiths	01/05/2024	20	35770
Taylors	01/05/2024	2	13982
Taylors	01/05/2024	1	1608
Taylors	01/06/2024	16	3388
Taylors	01/05/2025	27	3011
Smiths	01/06/2024	12	700
Taylors	01/05/2025	15	0
Smiths	01/06/2024	25	22645
Smiths	01/05/2025	16	77919
Taylors	01/06/2024	10	34700
Taylors	01/05/2024	28	11780
Smiths	01/05/2025	27	28793

[FBergamaschi]

Would something like this work?

[Julier]

Hi, thanks for your reply, unfortuanley this  doesnt sum the sales as the month goes on this just shows what the sales where on each day, what i want to see are the sales growing daily until we see the final sales figure at the end of the month, I also need both years showng without the need for a slicer in the way that this chart does, hope you can help?

[FBergamaschi]

How about my next reply?

yesterday

My pbix is here, with adjusted graphs like follows

https://drive.google.com/drive/folders/1e5xrhW22elwq9eVzh0H4NaUH0u7xB7iB?usp=sharing

If this information is helpful, please “Accept as solution” and give a "kudos".

Thanks

[Julier]

Unfortunately this doesnt work as it is not adding the sales together as the month goes on it is showing the daily sales for each day, and i have to use a slicer to show the months, I want to be able to show the overall comparison between the months for all sites eg the cumulative daily sales for May 24 and May 25 on one chart together with no slicer  and then be able to slice into each site for to show the individualy monthly  comparison so if the sales for day 1 are 1 and day 2 are 5 and day 3 are 8 I want the chart to show sales on day 2 as 6 and day 3 as 14 and so on.

[Julier]

Hi, an update on my earlier reply i can see now the running sum works but i cant get it to show both months/years  together at the same without the use of a slicer, as i previoulsy mentioned i need to show the month on month comparison together on the chart

[FBergamaschi]

My pbix is here, with adjusted graphs like follows

https://drive.google.com/drive/folders/1e5xrhW22elwq9eVzh0H4NaUH0u7xB7iB?usp=sharing

If this information is helpful, please “Accept as solution” and give a "kudos".

Thanks

[v-ssriganesh · Accepted solution]

Hello @Julier,
Thank you for reaching out to the Microsoft fabric community forum.

I’ve reviewed your scenario and reproduced it in Power BI Desktop using the sample data and logic you provided. I was able to get the expected output, with the running total accumulating day-by-day within each month, and split by Site and Month-Year. This also works seamlessly with slicers, just as you intended.

The visual now correctly compares multiple months side-by-side and reflects cumulative sales per site over each calendar month.

For your reference, I’ve attached the .pbix file please feel free to explore and adapt it to your dataset.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[FBergamaschi]

I can help but what is the meaning on the column day nr in calendar month? In the first row the date is may 1 but then there is a 20 in this other column, does that mean that the date column indicates the month and the day nr column the day in the month?

best

FB