Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
======
First post 🙂
======
Currently, I am working on a project which will help me identify certain areas that are not logging in or engaging with the portal they are provided.
I'm extracting the data from Dynamics ( CRM ) and trying to implement the raw data in a filled map on PowerBI.
I have 2 tables currently with the following :
Table no.1: Conference with active login to the portal in the last 31 days by association
- This table provides the following details :
-Columns: Name, New agresso code, last login to the portal, location, Area, Region code, Country, Region, Country, Country short for Bing
-Shows the user which *confrences have been actively logging in the past 31 days ( only shows last login in date/time format, not multiple figures for a confrence )
*A confrence is a location where all of the members meetup to liasie/work and logon to the portal "inhouse" > we have named the confrence under "Name" in both tables
Table no.2: Home visitation confrence
- This table provides the following details :
- Columns: Region, Area, Name, Location, Main activity, New agresso code, President, Home address
- We are focusing on the following columns : Name, Location/region & last login to the portal ( both tables contain Name & region : trying to build a relationship)
-Other columns can be ignored.
Desired outcome:
I have hit a brick wall and here are some of the things I have tried :
This is my Logic:
If confrence name[ From home visitation ] has login from this table [ Confrences with active login in last 31 days] : Green
If confrence name[ From home visitation ] has no last login from portal [ Confrences with active login in last 31 days] : Red
Specific confrences would be difficult to highlight, I can colour code based off regions also.
Apologies if this is confusing, this is my first post.
And I hope I can get some insights into where Im going wrong or maybe my logic is wrong.
Thank you in advance , I appreciate any help🙂
Solved! Go to Solution.
UPDATE **
I was able to view all the confrences not logging in/Interacting with the portal:
I used the following code :
UPDATE **
I was able to view all the confrences not logging in/Interacting with the portal:
I used the following code :
Hi, @Anonymous
Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |