Forum Discussion

pdeubner's avatar
pdeubner
Frequent Visitor
1 year ago
Solved

Create set/ order value from single row in set

Dear,   I currently have an issue where I seemingly meet my limits - even though I thought it should be quite easy to do. In a table, I have a lot of data out of our ERP system They have the foll...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Is this what you're looking for?

    resource2 = 
CALCULATE (
    MAX ( Data[ressource] ),
    FILTER ( ALLEXCEPT ( Data, Data[order no.] ), Data[phase] = 2010 )
)

     

danextian's avatar
danextian
Super User
1 year ago

Hi pdeubner 

I don't quite get this statement

 I would like to have the ressource of phase 2010 in the column head ressource for all rows of the corresponding order.

Using your sample data, what result do you expect?

 

Also, do you really need  those 200 columns or you only think you need them? While Power BI can handle that much columns, it can degrade the performance of your model.