Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 help
Solved! Go to Solution.
Hello,
It did not resolve my problem, perhaps because I did not know how to implement it for my case, but it inspired me to find another solution.
I created a calculated table (month, mesure1) and after that I was able to do the sum of the mesure month by month for a choosen period.
Thank you very much for your help
Hi,
Try something like this:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Hello,
It did not resolve my problem, perhaps because I did not know how to implement it for my case, but it inspired me to find another solution.
I created a calculated table (month, mesure1) and after that I was able to do the sum of the mesure month by month for a choosen period.
Thank you very much for your help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
73 | |
50 | |
45 | |
20 | |
17 |