Forum Discussion
Need help on the below requirement
Hi All,
how to achieve the output based on the below input in power bi ?
This will create a summary table as a solution
Assuming the input table name is "Input" and the output table is "Output"
go to modeling > new table and write this code
Output = SUMMARIZE(Input,Input[Base],"Sales",SUM(Input[Sales]),"Col",CONCATENATEX(Input,Input[Col],", "))
2 Replies
- yelsherif
Resolver IV
This will create a summary table as a solution
Assuming the input table name is "Input" and the output table is "Output"
go to modeling > new table and write this code
Output = SUMMARIZE(Input,Input[Base],"Sales",SUM(Input[Sales]),"Col",CONCATENATEX(Input,Input[Col],", "))Thank you yelsherif , it is working fine.