lbendlinSuper User5 years agoTry looking at the issue differently. In Power Query, in you main query add a filter to remove 2020 data. Then append your 2020 fixed value data to the main query.
Related contentDataflow Activity Parameters Lose Expression and Get Hardcoded After Reopening PipelineHardcoded Column expands table visual by all valuesDeneb: only hardcoded data works?hardcode last month dateHardcode Custom Row in PowerBI Matrix