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.
Hello everyone,
I have a dataset containing the Order column, date received and date shipped. I need a report where I can see the number of orders received and shipped every month and also the difference between them in order to understand how many orders are getting stucked.
But now, I have to acumulate the on hold totals, I have been trying some dax formulas but nothing seems to work, the on hold colum comes from a measure. At the end I need to have this:
Any idea? Thank you in advance.
Solved! Go to Solution.
I test this and Worked,
If i delete the "all" in the filter give me the result that you put in previous post.
TO give you another solution, Can you share a PBIX with your structure or sample?
Hi @brissae
Acum-Onhold = CALCULATE([Onhold];FILTER(all(Calendar);Calendar[Month]<= MAX(Calendar[Month])))
@Vvelarde keeps on giving me the same result:
ACUM = CALCULATE([ONHOLD],FILTER(ALL('CALENDAR'),'CALENDAR'[Month] <= MAX('CALENDAR'[Month]))) I've been trying with this measure all day but nothing changes, any other idea?
Thanks
I
I test this and Worked,
If i delete the "all" in the filter give me the result that you put in previous post.
TO give you another solution, Can you share a PBIX with your structure or sample?
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |