Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm trying to calculate the Sales Order Qty of items that fall under defined campaigns. However, the information is scattered across a few related tables as shown in the image below. What DAX formula should I use to calculate the total Sales Order Qty within campaign periods using the data from different tables?
Hi @wktan ,
It's better to share some sample data because you data model looks quite complicate.
Best Regards,
Jay
Hey @wktan ,
Please try using this measure :-
Sales Order Quantity = CALCULATE
(
SUM(SalesOrderLines[OrderSalesQuantity]),
DATESBETWEEN(SalesOrderHeadersV2[OrderCreationDateTime],
MIN(Campaigns[StartDate]),
MAX(Campaigns[EndDate])
))
Thanks @community_pinki for the suggestion.
I have tried using this measure and added it to a matrix visual (with all the campaigns listed on rows) but it shows the following error.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |