User Profile
chitti5
Helper I
Joined 2 years ago
User Widgets
Contributions
Not able to change Many to Many relation to One to Many relation
Hi All, I have two tables, each with over 40 columns. I want to connect them using a unique value which is alphanumeric that contains numbers,alphabets and special characters. However, when I tried, I ended up with a many-to-many relationship due to duplicate values in the columns. I can't append the tables because of their size. I attempted to add a bridge Dim table (deleted all duplicate values from the Dim Table column) to create a one-to-many relationship with each table, but I'm still unable to achieve the desired relationships. Could the issue be that the unique value column contains commas and slashes? I tried removing commas and slashes from the unique value column and even separated the columns containing these characters, but it didn’t solve the problem. The data types of both columns from both tables are also same i.e. "text". I’m still unable to establish the desired relationships between the tables. Can you help me figure out what’s going wrong? Screenshots below:Need help with count of projects per month
Hi, I need help visualizing project progress over time in Power BI. I have a table that includes 18 projects, each with Project Created dates and Project Completed dates. (For example, one project started in September 2024 and was completed on February 1, 2025. This project should be shown as "in process" for the months of September, October, November, December 2024, and January 2025, but it should not be counted as in process for February 2025 as it got completed. I want to create a measure or calculated column that shows the total count of "in process" projects for each month between created date and completed date by adding newly created projects and subtracting the completed projects to the existing count per month . This will be displayed in a line chart, with calendar months on the X-axis and the count of "in process" projects on the Y-axis. Yesterday, a community helper tried to assist me, but their approach didn't work out. I need to present this data to my client today, and I urgently need your assistance to find the right solution. Project Name Project Created date Project Completed date 1 Monday, September 16, 2024 Saturday, February 1, 2025 2 Sunday, December 1, 2024 4 Wednesday, November 20, 2024 5 Saturday, October 12, 2024 Friday, January 31, 2025 6 Tuesday, October 15, 2024 Monday, February 3, 2025 7 Friday, December 20, 2024 8 Friday, December 20, 2024 9 Friday, December 20, 2024 Wednesday, January 15, 2025 10 Friday, December 20, 2024 11 Monday, January 15, 2025 12 Friday, November 15, 2024 13 Friday, November 15, 2024 14 Tuesday, October 15, 2024 Sunday, December 15, 2024 15 Tuesday, October 15, 2024 Friday, January 31, 2025 16 Tuesday, October 15, 2024 17 Tuesday, October 1, 2024 Tuesday, December 17, 2024 18 Saturday, November 2, 2024 The possible count of in process projects on the line chart per month according to the above data should be Sep - 1 Oct - 7 Nov - 11 Dec - (11 from nov, +5 newly created Dec, - 2 projects completed in dec) = 14 Jan'25 - (14 from dec, +1 newly created in Jan, -3 projects completed in Jan) = 12 Feb'25 - (12 from Jan, -2 from Feb) = 10 Please help!Re: Need an Idea to update meeting notes
Hi Anonymous Thank you so much for sharing this idea. I tried this and was successful in creating a report web in sharepoint. But, the major reason for asking a new approach is to show the audience while updating notes and make live changes to the below screenshoted list I'll be presenting during the meeting. I'm not sure how to do that. I feel the idea you shared will embed the power bi into sharepoint list but I think from your idea I still need to go back to sharepoint list to update the notes and then refresh power bi to show the updated notes. This is my meeting notes layout after I embedded into Sharepoint list. Please let me know if there is any way to update the notes in this "meeting notes" card instead of going back to the list to update it. Thanks a lot in advance!!
