Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Running sum per month

Greetings everyone!   I'm fairly new to PowerBI development and currently I am having some issues regarding the implementation of a Running Total per Month. I've searched a lot before writing this ...
Need Help
Tips and Tricks
  • vivran22's avatar
    vivran22
    6 years ago

    Hello Anonymous ,

     

    You may try this:

     

    MTD SUM = 
CALCULATE(
SUM([VALUE]),
DATESMTD([date])
)

     

    Cheers!
    Vivek

    If it helps, please mark it as a solution
    Kudos would be a cherry on the top 🙂

    https://www.vivran.in/

    Connect on LinkedIn

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi vivran22, thanks for your help!

That works implemented as a measure!

 

One more quick question: can you give me any hints on how can I create a measure that could capture the dates in the current month? E.g. 01/april - Today, dinamically in the report, but it should not be varied with the Segment Data.

 

Thanks a lot!