Forum Discussion

exoticdisease's avatar
exoticdisease
Regular Visitor
8 years ago

Multiple date fields in Power BI

Hi

 

I wish to show both a transaction date and an invoice date column against some spend data.  I have the spend data, along with invoice date key and transaction date key in one table which has a relationship to the date table via a date key.  I am told that I can use the date key to connect to both the invoice date key and transaction date key but I need to do this simultaneously to show the two columns simultaneously, I believe.

 

I've been told to create a new relationship between the two tables using the invoice date key and the date key, make it inactive, then create a measure using sum(spend) and userelationship() with the new relationship but couldn't get this to produce meaningful results.

 

Any advice would be very helpful!

 

Need Help

8 Replies

  • exoticdisease's avatar
    exoticdisease
    Regular Visitor
    8 years ago

    These are the two tables in question with the fields and relationship visible.

     

     

     

     

    • exoticdisease's avatar
      exoticdisease
      Regular Visitor
      8 years ago

      Noone can help?  I just want three columns - invoice date, transaction date and spend... in my head, it should be easy!  Each invoice has one invoice date and one transaction date (e.g. paid date) so there's no issue with many to many relationships or anything...

       

      Thanks

      Rob

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi Rob,

         

        It should be easy. How do you want to show them up? If you just want to put them together, you can drag them together. But I don't think that's what you want.

        Multiple_date_fields_in_Power_BI

         

        Best Regards,

        Dale