Forum Discussion

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

Running sum

Hello, Im hoping someone can help, How can I get this measure to leave the running total for the rest of the month blank if there is nothing in the ytd corresponding column, at the moment it fills in...
Need Help
  • MarkLaf's avatar
    MarkLaf
    1 year ago

    I think you can get this by just updating your visual calc like so:

     

    Running sum = IF( NOT ISBLANK( [YTD] ), RUNNINGSUM([YTD]) )

     

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

Thank you for your reply unfortunately I need to be able to graph as below and as the data behind it has different sites attched to the sales I also need the graph to change when a slicer is selected, as you can see the chart flatlines at the last running total due to no sales from day 3 forward as yet, I want the current year line to grow as the month goes on 

 

SundarRaj's avatar
SundarRaj
Icon for Super User rankSuper User
1 year ago

Hi Julier , is this what you eyeing for? For achieving this, the code shall be as follows, thanks

Jul25 YTD =
VAR YearToDate =
CALCULATE(
    [Jul25],
    DATESYTD(
        'Calendar'[Date]
    )
)
RETURN
IF(
    [Jul25],
    YearToDate,
    ""
)

 

 

 

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

    Hello,  Im not sure I'm explaining myself clearly, the data is in the format below and as I have used the running sum to plot the visual i need for it to not calculate a running sum for he remainder of the current month if there are no sales  in the rest of the month as these will come in each day and then the line with continue to calaucate the running sum as the month goes on without flat lining 

    MonthYearDayInMonthVolume (SQM)
    Jul 24111212
    Jul 24158307
    Jul 2512438
    Jul 25164838
    Jul 25123257
    Jul 2513297
    Jul 2514976
    Jul 25142634
    Jun 25222630
    Jul 25238497
    Jul 24219799
    Jun 252332
    Jun 25220040
    Jun 25213830
    Jul 2426576
    Jun 2538275
    Jun 2535833
    Jun 2539159
    Jun 2536084
    Jun 2537421
    Jul-25310980
    Jul-25326144
    Jul-2532789
    Jun 25313031
    Jun 25322700
    Jun 2539945
    Jun 25319630
    Jun 24513251
    Jun 2556904
    Jun 25511494
    Jun 2559022
    Jun 2555420
    Jun 25531514
    Jun 25513277
    Jun 25510149
    Jun 2453802
    Jun 2453948
    Jun 2457335
    Jun 2456082
    Jun 2457916
    Jun 2453360
    Jul 2452243
    Jul 24514733
    Jul 2455725
    Jul 2457459
    Jul 2457621
    Jul 24618677
    Jul 2466060
    Jul 24629212
    Jul 2468882
    Jul 2463469
    • v-sgandrathi's avatar
      v-sgandrathi
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi Julier,

      Thank you for the follow up!

       

      After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used the data which you provided and successfully implemented it.  


      I am also including .pbix file for your better understanding, please have a look into it:

       

      Hope this will help you resolve your issue, if you need any further assistance, feel free to reach out.


      Thank you for using Microsoft Community Forum.