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 ...
HI achen ,
For your requirement, you need to add if statement to check current row contents and replace blank value with specific dax formulas.
BTW, does these blank parts really existed in your table? If not, I think you need to create a new table with all column fields to replace original column field, then you can write formulas to use current category and column label to calculate.
Regards,
Xiaoxin Sheng