Published on Dec 29, 2021:

In this video, we will learn to use the DAX userelationship function.


In the previous video, we learnt to use multiple date tables in Power BI. We also understood the best practices to use with multiple date tables.

Sample DAX code used in this example:
SalesAmountShipDate = CALCULATE(SUM(FactInternetSales[SalesAmount]), USERELATIONSHIP(FactInternetSales[ShipDate], DimDate[Date]))
SalesAmountDueDate = CALCULATE(SUM(FactInternetSales[SalesAmount]), USERELATIONSHIP(FactInternetSales[DueDate], DimDate[Date]))

Link to DAX USERELATIONSHIP function:
[ Ссылка ]


Previous Video:[ Ссылка ]
SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!
[ Ссылка ]


Download DAX Editor:
[ Ссылка ]

Our Playists:
Extract Load and Transform data using Power Query: [ Ссылка ]
Enhance Power BI Data model using DAX: [ Ссылка ]
Python and Power BI:[ Ссылка ]
Getting Started with AWS: [ Ссылка ]
SQL Playlist :[ Ссылка ]
DAX PlayList : [ Ссылка ]
Power BI PlayList: [ Ссылка ]
Power Query Playlist: [ Ссылка ]
Getting Started with Power BI:[ Ссылка ]
Getting Started with Python: [ Ссылка ]
Data Science With Python:[ Ссылка ]
Power BI service: [ Ссылка ]
Data Modelling with Power BI:[ Ссылка ]


ABOUT DAGDOO:
Website:
Home Page: [ Ссылка ]
Power BI Tutorials: [ Ссылка ]


Questions? Comments and SUGESTIONS? You will find me here:

Twitter: @dagdooe

Category: Science & Technology
License: Standard YouTube License

свернуть