How to Use Inactive Relationship In Power BI using DAX- USERELATIONSHIP - Interview Question PowerbI

This Video Gives you a clear cut explanation why Calendar Table is required in Power BI . And when we are using Calendar Table and a particular date , what date is being used by Power BI .
By Default Power BI uses Active Relationship between the two tables ,so if the relationship between the main table and the calendar table is based on Order Date , it will show based on Order Date . Using DAX - USERELATIONSHIP function we can also create measures that uses an inactive relationship and show data based on the Inactive relationship . This video uses "Sample Superstore" data set so that it is easier to understand the different relationship and how to use it .

*****************************************************

Instrovate has been delivering corporate trainings to Fortune 500 companies
like Abbott, AON, PepsiCo, NCR, Clifford Chance, GRI, TOI, Fidelity, Bajaj
etc, in Gurgaon, Noida, Pune, Mumbai, Sri Lanka. Instrovate has been conducting Data Analytics workshop based training
specific to modules, for e.g.,
 Data Analytics training for HR Group will be trained on HR specific
dashboards,
 Finance team will be trained on Finance specific Dashboards,
 CRM team on CRM Dashboards,
 Sales team on Sales Dashboards,
 SCM & Logistics Team will be trained on SCM &Logistic Dashboards.
Similarly, Instrovate conducts Data Analytics workshop specific to the user
groups like, we have
 different training modules for Leadership team, developers have a
different training module, induction training modules are different,
operations training modules are different.

Instrovate plans to continue on its endeavor of Data Democratization and
Data Driven Organization Enabler. We plan to Train workforce group from
both IT & Non-IT background in Data Analytics tools and present to them how Data can be the Game changer for their day to day decisions. We plan to
expand our Team on the respective tools & technologies in order to meet with the ever growing demand on the same.