PL 300 : Q2 - Power BI Aggregate Measure in One-to-Many Relationship
At @globalTechLearn, in this #video we will #practice the #aggregate #measure in One-To-Many #Relationships in #PowerBI .
Link to One-to-Many Relationship #question #video - • PL 300 : Q1 - Microsoft Power BI Relations...
#Question :
You have #PowerBI #datamodel that contains three #tables - #Sales , #Date and #Product .
The #Sales #table is related to the #Date and #Product #tables by using many-to-one #relationship .
The #Sales #table contains a #column named Total #Sales #Amount .
You need to create a #measure named Total #Sales that can be used to #visuals to #aggregate Total #Sales #Amounts by #product or by #date .
What should you use?
#dataanalysis #dataAnalyst #dataAnalytics #databasespecialist #datamodeling #datascience #DAX #Exam #FreeConference #Microsoft #MicrosoftPowerBI #PL300 #PowerBI #PowerBIConference #PowerBIDashboard #PowerBIDesktop #PowerBIforBeginners #PowerBIHowTo #PowerBIInterviews #PowerBIPro #PowerBITraining #PowerBITutorials #PowerBIWorkshop #Training