Forum Discussion
Unrelated Tables
Hi Anonymous, I created a measure as you had given. But, the calculated column using your previous expression (TotalSecond = IF([Condition Total]=BLANK(),0,[Condition Total])) throws this error:
A circular dependency was detected: BreakTime[Column], BreakTime[TotalSecond], BreakTime[Column]
Also, I actually want to update the total seconds in ItemTransaction table like below. I want the calculated break time beside each employee's record. Is this possible?
***Very importantly, can you advise me if we can put the other conditions in the same measure pleaseee?
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.
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
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.