Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have an table with data of sales orders, that get fetched every day. For this example, relevant is that i have an order number, a fetched date and a ordervalueamount for that giving day.
I have tried something in the lines of:
Any ideas to what to do?
Solved! Go to Solution.
Hi,
This measure pattern should work
Measure = SUMX(VALUES(Calendar[Month name]),[your measure])
Hi,
This measure pattern should work
Measure = SUMX(VALUES(Calendar[Month name]),[your measure])
Thanks for the reply
This works for the use case above, thanks!
You are welcome.
Thanks for the reply from @DataNinja777 , please allow me to provide another insight:
You're overthinking this question, just change measure to:
SUM('NavCurrentOrders (Fra SQL database)'[OrderValueAmount])
The subtotal could be working fine.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply, although this wouldn't work, as it wouldn't just sum the latest fetched data/row. A quick example of my dataset is such:
so for april or just the latest date for that sake, it should only return 200 and 340 for the two order numbers. Just summing, would add all the values together giving 600 and 1020 in this example
What about something like below?
VAR MaxFetchedDate =
MAX ( 'NavCurrentOrders (Fra SQL database)'[FetchedDate] )
RETURN
CALCULATE (
SUM ( 'NavCurrentOrders (Fra SQL database)'[OrderValueAmount] ),
KEEPFILTERS ( 'NavCurrentOrders (Fra SQL database)'[FetchedDate] = MaxFetchedDate )
)
Best regards,
Thanks for the reply, with this the subtotal still doesn't work
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |