Selected value vs. variable

Cassie_L — Mon, 03 Jul 2023 08:02:17 GMT

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])

Re: Selected value vs. variable

udit_k — Mon, 03 Jul 2023 12:26:27 GMT

use below expression :-

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

YTD:-

JAN-MAR:-