Date Columns in Different Data Sets

[dhodgson]

Hi, 

I have two sata sources which I need to have the dates combined as one. 

Essentially all rows from the SERVCARD data will either have an invoiced date from the SERVCARD data or an invoice date from INVOICES data under "INVDate" 

I need to be able to filter the dates as one date and show all the results from the servcard data across the entire report. 

Everything I have searched for is coming up for the same data set and not across two. 

Please help! 

[v-yinliw-msft]

Hi @dhodgson ,

You can try this method:

Merge the INV Date column to SERVCARD table:

SERVCARD table:

INVOICE table:

Transform data:

In SERVCARD table:

Is this what you expect?

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dhodgson]

Sorry, let me try to explain.. 

SERVCARD is my main data set that I need to use. However some Job #'s have an invoice date that doesn't come from this data set and comes from data set # 2 "INVOICES". How can I get the INV date from INVOICES data into the SERVCARD data under column C.INVDate. The date of 31/12/99 is reflective of a 'blank' entry in our system. 

I am trying to look at the revenue for a certain period of time. But with the invoice dates over 2x different data set's it not easy - Like I need an OR rule, to merge the data or something? 

I hope that makes sense - I am very new to PowerBi! 

Data set 1 - SERVCARD 

Job #	C.INVDate	Value
123456	12/12/2022	100.00
23456	31/12/99	2000

Data set 2 - INVOICES

Job #	INV Date	Value
123456	31/12/99	100.00
23456	01/04/2022	2000

[Anonymous]

Hello i didnt understand tour question very much if you could provide with some data it would be great but Have you tried creating a calendar table then creating a relationship brtween invoice date of both datasets with calendar one?