I am trying to fill blank cells in a column with previous non blank cell from that column. This is the formula I used
Solved! Go to Solution.
@Anonymous , try like
if(isblank(Table1[bench] ) maxx(filter(table, table[Eqmt Type] = earlier[[Eqmt Type] && table[interval end] < earlier[interval end] ),LASTNONBLANKVALUE(Table1[interval end],max(Table1[bench]))),Table1[bench])
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.