Sample Header Ad - 728x90

DAX Calculate the sum of values for a year with start date and end date

0 votes
1 answer
2239 views
I can't manage in **DAX**, to calculate for a year, the sum of the values which are in this year, I would like the proportion of each of the values in a year according to its starting date and its ending date. example For example, I want to be able to calculate for each year, the value of the "workload" during that year, so in 2019 the share of 150 between 01/02/2019 and the end of the year then the share of 150 between 01/01/2020 and 12/31/2020 then the share between 01/01/2021 and 05/05/2021 (without forgetting the phase 1-2 and the other IDs obviously).
Asked by Gabriel Valvin (63 rep)
Feb 22, 2022, 08:19 AM
Last activity: Feb 23, 2022, 03:53 PM