Forum Discussion
Solved
Put custom value between given dates
Hi, I have this data: Cust No Posting Date C10001 10/02/2019 C10001 26/02/2019 C10001 10/04/2019 C10001 30/04/2019 C10001 30/04/2019 C10001 08/05/2019 C10001 15/05/...
Download the PBI file from here.
Hi,
This calculated column formula works
=CALCULATE(SUM(Data1[Value]),FILTER(Data1,Data1[Lower]<=EARLIER(Data[Posting Date])&&Data1[Upper]>=EARLIER(Data[Posting Date])))
Hope this helps.
Value is manual input.
How can I input the value?
I do not understand your question/comment. The Data1 Table is a 3 column Table.
What I have is a 2 column table.
3 column table is my expected output 3rd column is calculated.
I am absolutely confused now. I have created the 3rd column for your in Table1 as per your initial request.