Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi @etiennesan
Try like below, Create a variable like "vMinForecast"
vMinForecast =Min(ForecastDate)
Sum({<Date={"<=$(=Date(vMinForecast,'YourDateFormat'))"}>} QuantityDestructed)
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?