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.
Hi
I have the below dataset, what im looking to do is to say:
Rounddown(Week 02 + Week 01,0) i.e 1,022.27 -15.48 = 1,006
Then moving the forumla needs to flow each week so:
1,022.27 - 1,006 -15.48 = 0.79
Then: Week 03: rounddown(1,985.6+0.79) = 1,986
Then again: 0.79 +1,985.6-1,986 = 0.39
going forward this needs to flow each week and be a measure
Thanks
Hi @wvdmpowerbi
I'm afraid it is impossible with measure/column.
You may write python code to implement it.
Best Regards
Maggie
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.