Only show budget for current year in visual

[Anonymous]

Hi. I have a visual showing sales for the last 12 months and would like to show the budget as well. However, I only want budget for current year, so from January - April 2024. Do I create a new measure for the budget, where the value is 0 if date/year is earlier than current year?

Any suggestions?

Thanks a lot in advance.

[Anonymous · Accepted solution]

Hi.

I solved it with below measure:

Budget Sales Current Year:=
IF(YEAR(MAX('Date'[Date]))=YEAR(NOW()),
[Budget Sales],0)

Thanks!

[Wilson_]

Hi HLVW,

Your idea would work, yes.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.