Accelerate your Career and Get Certified
Friday, June 25th, 2021
Welcome to your Model Data in Power BI
With a single cross-filter direction between two tables with a one-to-many relationship, filtering will be done by
Total Sales for 2015 = CALCULATE(SUM('Sales OrderDetails'[Total Price]), YEAR('Sales OrderDetails'[orderdate]) = 2015)
Sales by Ship Date = CALCULATE(Sales[TotalPrice], USERELATIONSHIP('Calendar'[Date], Sales[ShipDate]))
Time is Up!
Your email address will not be published. Required fields are marked *