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

vivran22's avatar
vivran22
Community Champion
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!