Set analysis with inferior for measure

[etiennesan]

Hello everyone,

I am trying to build a bar chart where my measure is called ForecastDate, but then I want to show the sum of the data for with Date is inferior to the ForecastDate of the current bar.

I tried with this formula:

 Sum({<Date={"<$(=ForecastDate)"}>} QuantityDestructed) 

But it is not working.

I found a few solutions of how to do it when using variables, but none about explaining how to do it when using the measure.

Thank you very much for your help!

[MayilVahanan]

Hi @etiennesan 

Try like below, Create a variable like "vMinForecast"

vMinForecast =Min(ForecastDate)
Sum({<Date={"<=$(=Date(vMinForecast,'YourDateFormat'))"}>} QuantityDestructed)

[etiennesan]

Hello,

Thank your for your reply!

I guess I was not clear enough, I want this to be dynamic to be used in my graph. For example see below:

This is what I currently have. I want to add to each bar the sum that I am trying to write. 

Am I using the right approach?