topic Re: Merging between two columns depending in three different conditions in DAX Commands and Tips

Merging between two columns depending in three different conditions

ZeinabGad — Tue, 18 Jun 2019 21:00:05 GMT

Hello,

I'm facing a problem with the data I have

In one table, I have a line, the shift and day, these three identify the row (Loading time) I need the Power Bi to fetch.

In the other table (Machine breakdown) I have the same date, line and shift but they are repeated for different machines

I need to calculate the percentage of contribution of that machine in breakdowns from the time of the shift.

Any Idea how?

Re: Merging between two columns depending in three different conditions

parry2k — Tue, 18 Jun 2019 22:01:22 GMT

ZeinabGad can you share sample data to show how your tables are and if they have relation?

Re: Merging between two columns depending in three different conditions

Amit2019 — Wed, 19 Jun 2019 11:58:22 GMT

Can you please share the Sample data and the desired output ?

Thanks,

Amit Dhiman

ZeinabGad wrote:
Hello,

I'm facing a problem with the data I have

In one table, I have a line, the shift and day, these three identify the row (Loading time) I need the Power Bi to fetch.
In the other table (Machine breakdown) I have the same date, line and shift but they are repeated for different machines

I need to calculate the percentage of contribution of that machine in breakdowns from the time of the shift.

Any Idea how?

Re: Merging between two columns depending in three different conditions

Amit2019 — Wed, 19 Jun 2019 11:59:22 GMT

Can you please share the sample data and the desired output ?