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 did rolling data by week, for qty_shipped, here is the fomular,
Solved! Go to Solution.
The condition stopping this data at week 33 is the following:
Shipped[Week_Shipped]<= MAX(Shipped[Week_Shipped])),
So you either need to just remove that conditition or maybe use the same max date as your ToCome , Backlog or Plan measures.
thank you. I tried to remove the condition, it expand to last week, but the total amount calculated a wrong number.
Oh yes, I see what that is doing. I don't normally use date columns directly in the fact table for filtering. I usually create a separate date table and then hide the date columns in the fact table. The date table should then have all the dates in the range you want to report on (so maybe all the days in 2019).
Then you could build your calculations using the following pattern
then I tried another one,
in the screenshot below,
list 2, calculation rolling is correct but can not expand more weeks.
list1, expand but rolling data is not right.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |