Forum Discussion
calculating the time difference between a direct querry column and a sharepoint list column
Hello,
Sorry I am fairly new to Power BI. Here is my problem. I have a Power BI file for project management, which I have a direct query data source and a data source from a sharepoint list. I want to create a new column that calculates the project award length. There is a column in the direct query data source called 'Created Date' and another in the Sharepoint list 'DateWon'. Both data sources have a column for 'Project number', the direct query data source one is called 'ProjectCode' and the sharepoint list is called 'Title'. I think I have linked the two using these connections.
I made sure both date columns are date formatted and have created a new column in the direct query datasource and attempted to subtract the two. However the following error occurs ' A single value for column 'DateWon' in table X cannot be determined.
Any help would be much appreciated.
2 Replies
StickyToffeePud what is the relationship between these two tables? One to One or One To Many?
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
Hi, I believe it is one to one, the value in the shared column between the datasources will be unique in each data source. Each data source only has 1 row per project code.
