Hi all,
I have some problem to find the value by selected Date in set analysis.
In my sheet, I have a Filter Pane which is a Date value from my data set.
In one of my table, I need the sales value which is the Date (from Filter Pane) minus 28 days. e.g 27/4/2020
So I have created a variable v_DD which can populate the correct date - populate 30/3/2020 (have format set up)
I need to get my sales value
sales = sum( { 1<Date ={ " =$(=v_DD )"}>} sales)
It seems correct - because I can see in the bottom of my formula screen it populate
=sum( { 1<Date ={ " =30/3/2020$ "}>} sales)
However, the my dashboard still populate the 27/4/2020 sales data, not 30/3/2020
I also tried only use the date value , not variable, but it still only populate the sales vale based on the filter pane selection.
Any help will be very appreciated.
Thanks
MC
