Forum Discussion

nirrobi's avatar
nirrobi
Icon for Helper V rankHelper V
10 years ago
Solved

Can not create visual (table) from 2 related table that connect properly (I think)

Hi all,   I face strange situation,   I have table for invoices and table for arrival date (both have date column as it not the same date), I want to create visual (table) that shows the sales i...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    nirrobi

     

    Based on my test, the problem is caused by the relationship among tables. If the relationship is 1:1,1:1 among the three tables, the original table visual in your pbix would work.

    In your case(many:1,many:1), use two measures instead.

    MAX INV DATE = MAX(INVOICES[INV DATE])
MIN SALES DATE = MIN(SALES[SALES DATE])




    If you have any question, feel free to let me know.

nirrobi's avatar
nirrobi
Icon for Helper V rankHelper V
10 years ago

Eric_Zhang

 

thanks for your reply.

 

I read the documantation but no help. I think is not my case.

 

append query - yes with remove duplicate else it not working.

conncection is indeed sales ID to sales ID to sale id no date in the relation ship.

 

I try to make table of sales id -sales date - inv date

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

nirrobi

 

Is it possible for you to upload the pbix?

  • nirrobi's avatar
    nirrobi
    Icon for Helper V rankHelper V
    10 years ago

    i try but not find where I can uplod pbix file, can you help please.

     

    many thanks.

    • Eric_Zhang's avatar
      Eric_Zhang
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      You can upload an attachment when replying.

      • nirrobi's avatar
        nirrobi
        Icon for Helper V rankHelper V
        10 years ago

        sorry.

         

        I can't find it :-((((

         

        only pic as attached