Forum Discussion
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...
amitchandak
Super User
Super UserAnonymous , 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))
amitchandak I have tried this but unfortunately this doesn't help to resolve