Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
I've tried a lot diff Dax to calculate a Chart to show the Budget for 12 months vs. YTD for the accumulated amount by the current month or something like Jan-Apr.
But as you can see below, it calculates properly until April, and after that, they keep the same amount through the year. And my idea for the current value is to show it until April and stop.
Solved! Go to Solution.
Hi, @Anonymous
I am not quite sure how your measures look like, but please try something like below for your Current Acc Rev Meausre.
New Measure =
IF ( NOT ISBLANK ( [Current Rev] ), [Current Acc Rev], BLANK () )
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.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
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 @Jihwan_Kim
Thanks for the answer, but in my case, it does not work because the "current" numbers are composted like this:
Jan - Current $
Feb- Current $
Mar- Current $
Apr- Current $
May to Dec - Forecast $.
The dax I've tried in the end was this:
Hi, @Anonymous
Thank you for your feedback.
Please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.
Thanks.
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 @Jihwan_Kim I have to add another column to identity if the numbers are Current or not, after that, I've used your New Measure =
IF ( NOT ISBLANK ( [Current Rev] ), [Current Acc Rev], BLANK () ).
Thank you very much
Hi, @Anonymous
I am not quite sure how your measures look like, but please try something like below for your Current Acc Rev Meausre.
New Measure =
IF ( NOT ISBLANK ( [Current Rev] ), [Current Acc Rev], BLANK () )
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.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
20 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |