add up
1 Topic
cumulate a mesure month by month from a startdate to an enddate
I have a measure Mesure1 that I calculate according to a chosen month and year. now I want to use this mesure to calcul another mesure. the rule is that when I choose a periode : startdate to enddate, the new mesure "Mesure2" should accumulate the result of the mesure1 for each month from the startdate to the enddate and finally this result should be divided by the number of months that are includes on the periode between the startdate to the enddate How can I do this with dax ? thank you for any helpSolved706Views0likes2Comments