Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I have the requirement to create a Power Bi Report to show the number of Phone Calls that a contact received in a month.
I have got the both Contact and Phone Call table in the Power Bi but not sure how to show the Phone Call Count for the Contact. Please advise the steps or examples on how this can be achieved.
Get data using Odata feed for "activitypointers" and "contacts" table/entity.
After getting data, transform data using power query. Remove unnecessary columns.
In activitypointer there is a column named "regardingobjectid_contact" that is a record, select "contactid" and any other columns you required.
once transformation is done, close and apply it navigates to data model. In data model go to model/relationships and create 1:N relationship between contact and activitypointers table.
In contact table create new column, using dax formula to display contacts phone call count for a month is =>
(CALCULATE(COUNT(activitypointers[contactid]), activitypointers[activitytypecode] = "phonecall", DATEADD(activitypointers[createdon].[Date],-1,MONTH))).
create any powerbi chart and in value include newly created column and in axis provide contacts full name.
Business Applications communities