Forum Discussion

tracy's avatar
tracy
Frequent Visitor
9 years ago

Unrelated Tables

Hi. I've tables that are not related as you can see in the picture below (no unique values in either one to create relationship). But, I need to pick a row from ItemTransaction table and check upon B...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi tracy,

 

Below is my pbix file, please check it if it works on your side.

 

Regards,

Xiaoxin Sheng

tracy's avatar
tracy
Frequent Visitor
9 years ago

Hi Anonymous, I'm just enlightening you that I want the break time total seconds to be put into ItemTransaction table as per what I've stated above. Is that possible or not? Please advise. 

 

And FYI, when I tested your measure at my end, my result is different from yours. See here.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi tracy,

     

    >> I'm just enlightening you that I want the break time total seconds to be put into ItemTransaction table as per what I've stated above. Is that possible or not?

     

    Yes, it is possible.  In my opinion, dax query not good at replace values with multiple conditions. It is hard to loop multiple tables and replace the value at same time. Perhaps you can use power query.

     

    Regards,

    Xiaoxin Sheng

  • tracy's avatar
    tracy
    Frequent Visitor
    9 years ago

    Hi Anonymous, I don't mind using power query too. Is there any basic or simple example that shows looping through conditions for unrelated tables? I really need to find a solution to produce break time into the ItemTransaction table.

    As far as I browsed through, I see that Power Query is used to customize columns and its values. 

    Please redirect me if you know of any sample. It'll be very helpful to me. Thanks.