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...
Need Help
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

      • exoticdisease's avatar
        exoticdisease
        Regular Visitor
        8 years ago

        Hi Dale

         

        The problem is that I need to connect both s_keys to the date table to make them recognisable as dates rather than just strings of numbers (e.g. the keys).  But you can't have two relationships between one table active at once so I can't display both sets of dates?  I think..

         

        Thanks

        Rob