Forum Discussion
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...
Is this what you're looking for?
resource2 = CALCULATE ( MAX ( Data[ressource] ), FILTER ( ALLEXCEPT ( Data, Data[order no.] ), Data[phase] = 2010 ) )
Hi danextian ,
thank you for your swift feedback and your remarks.
Based on my sample data, I would expect in all rows for
order 123456 stating UMP_01 in the column head ressource and for
order 123457 stating UMP_02 in the column head ressource
And thank you as well for your remarks on the performance. I will have a look into the needed columns as soon as the report is finished.