Save data in visuals despite source updates

[chloesouss]

Hello,

 I have Two data sources : principal data, list of applications data

(There is a relation between them)

On my visual, i use formula : average ( and the divide number : is the total of applications of my data source). But on 2023, i have 63 applications but in 2024 i have 43 applications so how can i keep my result on 2023 with the 63 applications on the same visual and for 2024 have the result with 43 applications without update 2023 data ?

Thank YOU

[amitchandak]

@chloesouss , if both of them have date or year, You should join both tables with common dimensions. One such decision would be Date or year and then you can analyze them by year

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.