Forum Discussion
Replace null values with conditional average
Help please! I'm still fairly new to Power BI and am trying to replace null values in my data with the average of the previous 3 months with some conditions. I have simplified the 2 tables to demo...
Would you still happen to have this file and can attach? I still can't seem to replicate the result, and i also don't fully understand the code in laymans terms to be able to troubleshoot exactly where i'm going wrong
wrote this code in a temp workbook without saving. sorry for that