Forum Discussion

tim-hammond's avatar
tim-hammond
Frequent Visitor
10 years ago
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 ...
  • Anonymous's avatar
    Anonymous
    10 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

tim-hammond,# I'm glad my solution helps you !!!

 

Keep going !

itchyeyeballs's avatar
itchyeyeballs
Icon for Impactful Individual rankImpactful Individual
10 years ago

Good to see you got it working

 

The potential advantage of using a measure instead would be that it would be more flexble going forward, for example if new teams were introduced you wouldn't need to add columns.

 

The measure could just be something as simple as Count(id_column) where id_column is any column in your data which has data for each row.

 

Then just put the measure into the value box and your CustPriority column into the legend box and PBI will automatically create a data set for each team.