Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
It works! Thank you Jihwam Kim!
User | Count |
---|---|
84 | |
79 | |
63 | |
62 | |
51 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |