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.
Dear All!
I would like to kindly ask for your help with the following.
I would like to calculate the cummulative avarege of daily sales higher, than 2.
Date Sales Conditional average
2021.06.01 1 0
2021.06.02 2 0
2021.06.03 4 4
2021.06.04 6 5
2021.06.05 2 5
What I would like to achieve is in column "Conditional average".
Do you have any suggestion of dax systanx what can give the awaited result?
Thank you in advance
Br,
S.
Solved! Go to Solution.
Hi, @Anonymous
Thank you for your feedback.
Please check the below.
The best way to understand it is to remove it from the formula and compare the results.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
Please check the below picture and the sample pbix file's link down below.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Jihwan_Kim !
I forgot to say, that the "sales" column is a measure already (sum of sales). Thus it is not working inside the Allselected function.
Do you have any idea for this alteration?
Thank you
S
Hi, @Anonymous
Please share your sample pbix file's link here.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
Thank you for sharing.
Please check the link down below.
https://www.dropbox.com/s/im0kkz3yajo89qn/Average.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Dear @Jihwan_Kim
I understood almost every part of your syntax.
Can you please help me with understanding the red highlighted parts?
Thank you
S.
Hi, @Anonymous
Thank you for your feedback.
Please check the below.
The best way to understand it is to remove it from the formula and compare the results.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |