Forum Discussion

mussaenda's avatar
mussaenda
Community Champion
6 years ago
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/...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Download the PBI file from here.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

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.