RELATED (DAX) Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/related-dax/ Bestselling Excel and Power BI Courses Fri, 10 Mar 2023 16:10:29 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png RELATED (DAX) Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/related-dax/ 32 32 How to Do Many-to-One Side Calculations in Data Models with DAX https://www.xelplus.com/dax-many-to-one-side-calculations/ Thu, 10 Mar 2022 10:00:00 +0000 https://www.xelplus.com/?p=9406 In Power BI or Power Pivot, you often need to create reports that go from the many side of the relationship to the one side. How can you do that without expanding your data model by adding more columns to your table? There is an easy trick you can use to solve this with a single DAX formula. Of course, the formula uses the CALCULATE function.

The post How to Do Many-to-One Side Calculations in Data Models with DAX appeared first on Xelplus - Leila Gharani.

]]>