Forum Discussion
Solved
echo a cell to a new column
Hello People, I am completely new to Power Bi and i find it facinating. My Background is infastructure HypeV and VM Ware Et Al...So excuse me if this is a simple thing I have a web query which ...
That's what I thought. Did you try to replace your formula by the one I gave you?
For example, for the first record I see, Instead of having 1246, 1577, 931, you should have 1, 0, 0
For the 4rd record, if you change the formula for the three columns, you should have 0, 0, 1.
So, the aggregation function should work.
Séebastien
Hello tim-hammond
The formula you wrote will count all the row in you table according to the filter you put. So it will put the same data for each record.
Perhaps you could just change the formula like this :
Green Team = If([CustPriority]="Green";1;0).
The aggregation function should be positionned on sum and I think you could do the job.
Tell me if it helps you.
Sébastien