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.
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.
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 |
---|---|
109 | |
100 | |
83 | |
76 | |
65 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |