Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Previous Value when the data is NULL for current selection

Hello,

I have just started with Power BI and I have a scenario but could not figure out the solution .Below is sample data.


When a user select any 'Start Date' in 2019 from the slicer, instead of showing blank for Product A it should show previous date avaliable price , in this case '50'. 

I have tried Earlier() and ISBLANK() to get this. amitchandak Greg_Deckler Any inputs to get this.

ProductStart DateEnd DatePriceApproved Date
A1/1/201811/11/2020506/11/2017
A11/12/20203/31/2021606/11/2017
A4/1/2021-706/11/2017
B1/1/2019-10012/5/2018

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Try a measure like

     


    measure =
    var _1 = calculate(max(Table[Start_date]), allexcept(Table, Table[product]))
    var _2 = sum(Table[price])
    return
    sumx(values(Table[Product]), if (isblank(_2) ,calculate(_2, filter(all(Table), Table[Date] =_1 )), _2))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak I have tried this but unfortunately this doesn't help to resolve