Forum Discussion
ItoDiaz
Helper I
Helper IReversing my master tab
Hello, In Excel I have two tab, “Master” and “Red P”. Initially, I needed use only “conformity toy” and “conformity CP” columns in Power BI. Now I need to show in a Histogram conformity of...
ItoDiazHelper I
Helper I
Yes, I have tried it at least four times, but PBI don't answer and I must stop process of the task. That is only the first question.
I think I dind't clearly described my real question : how could I "Translate" this operation from excel in PBI?
=100*(SUMPRODUCT((Mastertable[CP xx]=1)*(Mastertable[Date]=REDtable[Date]*1))/(SUMPRODUCT((Mastertable[CP xx]>=0)*(Mastertable[Date]=REDtable[Date]*1))"
Knowing I have 23 CP xx and I need to do the same operation for each one by day. And I want to have my "CP xx" in rows.
ex :
| PCP | Date 1 | Date 2 | Date 3 | .... |
| CP_CONDUCT_AA | result a | result b | .... | |
| CP_TEMP_AA | result xx | .... | .... | |
| CP_BRO_AA |