Forum Discussion
Table Creation in Power BI
Hi Team, I want help from the group where i have an excel table which need to be converted into a specific table based on condition. Excel Sample - Project Project 2 Target Date Days Count ...
BIswajit_Das
Impactful Individual
Impactful IndividualHello kinitundi
You can visualize the above data using a matrix and can acheive what you need.
or
You can create measures to get your results.
or
You can create a calculated table as per your requirement and get the required result. This below DAX may comes handy.
ResultTable =
SUMMARIZECOLUMNS(
'YourTable'[Project],
"30", CONCATENATEX(FILTER('YourTable', 'YourTable'[Days Count] = 30), 'YourTable'[Project 2], ", "),
"60", CONCATENATEX(FILTER('YourTable', 'YourTable'[Days Count] = 60), 'YourTable'[Project 2], ", "),
"180", CONCATENATEX(FILTER('YourTable', 'YourTable'[Days Count] = 180), 'YourTable'[Project 2], ", ")
)
Thank you very much, it helped me