Forum Discussion

atjt217's avatar
atjt217
Icon for Helper III rankHelper III
5 years ago
Solved

Sum based of current date

Hello PBI Wizards im hoping to ask your help to solve this:  What im trying to do is to figure out a measure formula to get the sum of revenue based of current date. For example: today 4/6 shoul...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, atjt217 

    Please try to write something like below.

     

     

    newmeasure =
    VAR currentmonth =
    MONTH ( TODAY () )
    RETURN
    CALCULATE (
    [Revenue],
    FILTER (
    ALL ( yourdatetable ),
    datecolumn <= TODAY ()
    && monthnumbercolumn = currentmonth
    )
    )

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, atjt217 

Please try to write something like below.

 

 

newmeasure =
VAR currentmonth =
MONTH ( TODAY () )
RETURN
CALCULATE (
[Revenue],
FILTER (
ALL ( yourdatetable ),
datecolumn <= TODAY ()
&& monthnumbercolumn = currentmonth
)
)

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

atjt217's avatar
atjt217
Icon for Helper III rankHelper III
5 years ago

It works! Thank you Jihwam Kim!