Forum Discussion
Date Columns in Different Data Sets
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!
3 Replies
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 
v-yinliw-msftCommunity Support
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.
