Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |