medium10 pts · first answer countsdata-visualizationdaxdata-modeling

Sales by ship date and order date

Sales has OrderDate and ShipDate, both related to the Date table, but only the OrderDate relationship is active. How do you build a "Sales by ship date" measure?

A.Make both of the relationships active at onceB.Duplicate the whole Sales table for ship datesC.CALCULATE with USERELATIONSHIP on ShipDateD.FILTER(Sales, Sales[ShipDate] = TODAY())

Discussion 0

Join free to post in the discussion.

Sales by ship date and order date

Discussion 0

Related questions