Forum Discussion

VTur's avatar
VTur
Frequent Visitor
3 years ago

Running total in graph with blank/missing dates

Hi guys, I've read lots about on this forum about how to andle blanks/missing values in running totals but none helped me in solving my problem (I must point out that these are my firsts months on P...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Revise your measure to:

Cumulative Total Tipo Movimento = CALCULATE([Total Tipo movimento],DATESBETWEEN('Calendar Table'[Data],MINX(ALL('Calendar Table'),'Calendar Table'[Data]),MAX('Calendar Table'[Data])))

Ensure that on the X-axis of the visual, you drag Month/Year from the Calendat Table. 

  • VTur's avatar
    VTur
    Frequent Visitor
    3 years ago

    HiAshish,

    unfortunatly that's the output:

    ā€ƒ

    It gives back the total for each day and other errors.

     

    Here's the CSV of the outputs in case you need (WeTransfer: https://we.tl/t-a8qPgjJaE6) :

    - "Your formula" contains the result of your formula in the graph

    - "Previous formula" contains the result of my formula in the graph, the empty cells are the ones i want to fill

     

     

    Thank you for your support!