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.
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.
Above photo is my data.
then I will put these values based on date on a calculated column. It is not existing on my current data.
After the calculated column created, this is the expected output:
Then if i will create a visual, this is the expectec output:
My formula returns the third column shown in your Final Output Table.