Forum Discussion
Powerbi table connection
Hi Anonymous ,
After reviewing the provided screenshot, we identified a potential data type mismatch between the Datum[Date] column (formatted as DateTime) and the
Objectifs promoteurs[Mois]column (formatted as Date). This inconsistency could contribute to errors when establishing relationships between the tables.To expedite troubleshooting, could you kindly share a simplified .pbix file that replicates the issue? Please include a brief description of the expected outcome in the file or your response. This will allow us to:
-
Validate the root cause of the relationship error.
-
Replicate the scenario and test solutions efficiently.
You can securely upload the file using the community portal here:
How to upload PBI in CommunityNote: Ensure sensitive data is removed or anonymized before sharing.
Thank you for your collaboration. We’ll prioritize resolving this once we receive the sample file.
Best Regards
-
Hello, sorry for my response delay. This is the result I want to achieve:
I would like to have the monthly objective for each line and not the overall objective.
Thank.
Hi Anonymous ,
Could you please provide guidance on how to determine the monthly objective for each line? Additionally, I would appreciate it if you could share the related calculation logic and the expected values for each line based on the sample data you provided. Thank you.
Best Regards
Hello, yes the objective is completed by me in a table stored in sharepoint.
But I cannot connect the datum table with the objective table which contains the dates, in order to have a monthly distribution
Hi Anonymous ,
After reviewing the provided screenshot, we identified a potential data type mismatch between the Datum[Date] column (formatted as DateTime) and the
Objectifs promoteurs[Mois]column (formatted as Date). This inconsistency could contribute to errors when establishing relationships between the tables.To expedite troubleshooting, could you kindly share a simplified .pbix file that replicates the issue? Please include a brief description of the expected outcome in the file or your response. This will allow us to:
-
Validate the root cause of the relationship error.
-
Replicate the scenario and test solutions efficiently.
You can securely upload the file using the community portal here:
How to upload PBI in CommunityNote: Ensure sensitive data is removed or anonymized before sharing.
Thank you for your collaboration. We’ll prioritize resolving this once we receive the sample file.
Best Regards
The problem is solved! Thank you!
-