Forum Discussion
Enter Formula Into Matrix
Hi, I have the following matrix and I would like to fill in the empty fields with a formula that references the other values in the matrix. The BDG comes from 1 table and the STD and Actual ...
It's not really clear what your base data looks like but perhaps
you could write a measure that tests for blank values and
if it finds a blank, then tries to compute a value from the other rows.
Being able to detect the blank value would be the first step.
Another approach would be to investigate why there are blank rows in the data you are
loading, and take steps to fill in the values there...before you load the data into power bi.