Forum Discussion
Baarathi88
6 years agoHelper III
Multiple Date Mapping
I have a data set with three date fields OrderDate, ShippedDate and DeliveryDate. I want to calculate sales in a Card Visual. Card 1 : Sales based on Order Date Card 2 : Sales based on Shipped ...
- 6 years ago
Hi Baarathi88 ,
You will need to use dax function UseRelationship for this purpose. This function allows you to use inactive join between tables to create calculation based on different days.
This link will help you: https://docs.microsoft.com/en-us/dax/userelationship-function-dax
Example 1st measure= CALCULATE(SUM(InternetSales[SalesAmount])
Example 2nd measure - inactive relationship: = CALCULATE(SUM(InternetSales[SalesAmount]), USERELATIONSHIP(InternetSales[ShippingDate], DateTime[Date]))
Cheers,
Nemanja - 6 years ago
you will need to create three measures,
like
order_date_sales = sum('Sheet1'[Sales]) ship_date_sales = calculate(sum('Sheet1'[Sales]), userelationship('Sheet1'[ShippedDate], Dates[Date])) delivery_date_sales = calculate(sum('Sheet1'[Sales]), userelationship('Sheet1'[Delivery Date], Dates[Date]))
richbenmintz
6 years agoResident Rockstar
you will need to create three measures,
like
order_date_sales = sum('Sheet1'[Sales])
ship_date_sales = calculate(sum('Sheet1'[Sales]), userelationship('Sheet1'[ShippedDate], Dates[Date]))
delivery_date_sales = calculate(sum('Sheet1'[Sales]), userelationship('Sheet1'[Delivery Date], Dates[Date]))
Baarathi88
6 years agoHelper III
Thank You. That works