Forum Discussion

Julier's avatar
Julier
Icon for Helper III rankHelper III
1 year ago
Solved

power bi measure

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

SiteDateDay Number in Calendar MonthVolume (SQM)
Smiths01/05/20252014846
Taylors01/05/20253011153
Smiths01/06/20252422412
Taylors01/06/20251113355
Taylors01/05/20242315495
Taylors01/05/202496728
Taylors01/05/202428764
Taylors01/06/20251818852
Taylors01/05/2025510303
Taylors01/05/202436147
Taylors01/05/202423472
Taylors01/05/2025132991
Taylors01/06/202459223
Smiths01/06/20242813091
Smiths01/06/202524068
Taylors01/05/2024248946
Smiths01/05/2025914725
Taylors01/05/20251888
Smiths01/05/202424934
Taylors01/05/2024240
Smiths01/05/20242035770
Taylors01/05/2024213982
Taylors01/05/202411608
Taylors01/06/2024163388
Taylors01/05/2025273011
Smiths01/06/202412700
Taylors01/05/2025150
Smiths01/06/20242522645
Smiths01/05/20251677919
Taylors01/06/20241034700
Taylors01/05/20242811780
Smiths01/05/20252728793
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    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.

8 Replies

  • FBergamaschi's avatar
    FBergamaschi
    Icon for Super User rankSuper User
    1 year ago

    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

  • v-ssriganesh's avatar
    v-ssriganesh
    Icon for Community Support rankCommunity Support
    1 year ago

    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.