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 rolling sum measure as below which measures 3 weeks rolling of column "periodic:Earned". I want another measure which only calculate the the last period rolling sum and everything else to be zero. For example, in the below table, only shows the rolling sum for 16-Apr-21 (26.07) and all previous periods to be zero.
Can somebody help?
Solved! Go to Solution.
Hi, @amirghaderi
I am not sure hour your whole data model looks like, but the simplest way (in my opinion) is, adding an IF condition something like below.
Qty total 21days rolling =
if ( not isblank( [Qty total]), your measure......)
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, @amirghaderi
Please check the below picture and the sample pbix file's link down below.
All measures are in the sample pbix file.
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: www.linkedin.com/in/jihwankim1975/
Twitter: www.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.
Not sure why "Qty total 21 days rolling comes blank.
Hi, @amirghaderi
I think, in your table visualization, the Dates[Date] is not used. Instead, [Date to 2] is used.
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.
Thanks for your response, it looks much better now. How can I stop the calculating moving sum for future periods, highighted below?
Hi, @amirghaderi
I am not sure hour your whole data model looks like, but the simplest way (in my opinion) is, adding an IF condition something like below.
Qty total 21days rolling =
if ( not isblank( [Qty total]), your measure......)
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.
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |