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 invoic...
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 |