Selected value vs. variable

[Cassie_L]

Hi, All,

I have a variable formulas to show YTD budget. But when I select Jan - Jun, it will always shows YTD budget instead of Jan - Jun. 

How can I show selected value when I apply filer, and show YTD value when I do not have filter?

Sum({<Version={"Budget"},[Calendar Year]={$(=maxstring([Calendar Year]))},
Month={'<=$(=(max({<Month={$(=month(today()))}>}Month)))'}>}[Net Sales])

[udit_k · Accepted solution]

use below expression :-

=sum({<Year={"$(=max(Year))"},Month={"<=$(=num(month(Max([Start Date]))))"}>} value)

YTD:-

JAN-MAR:-