calculating the time difference between a direct querry column and a sharepoint list column

[StickyToffeePud]

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.

[StickyToffeePud]

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. 

[parry2k]

@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! ❤️