Sum based of current date

[atjt217]

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 should be a total of $87,705.00. Then it needs to be able to adjust depending on current date. So once tomorrow comes its going to be $108,270.00.

[Jihwan_Kim · Accepted solution]

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]

It works! Thank you Jihwam Kim!