Forum Discussion

kinitundi's avatar
kinitundi
Frequent Visitor
3 years ago

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 - 

ProjectProject 2Target DateDays Count
KBFeat 111-06-202330
KBFeat 212-07-202360
KBFeat 313-06-202330
KBFeat 414-07-202360
KBFeat 515-09-2023180
APPMMMFeat 111-06-202330
APPMMMFeat 212-07-202360
APPMMMFeat 313-06-202330
APPMMMFeat 414-07-202360
APPMMMFeat 515-09-2023180
IntegrationFeat 111-06-202330
IntegrationFeat 212-07-202360
IntegrationFeat 313-06-202330
IntegrationFeat 414-07-202360
IntegrationFeat 515-09-2023180

 

Output -

Project306090180
KBFeat 1, Feat 3Feat 2, Feat 4 Feat 5
APPMMMFeat 1, Feat 3Feat 2, Feat 4 Feat 5
IntegrationFeat 1, Feat 3Feat 2, Feat 4 Feat 5
Need Help

2 Replies

  • BIswajit_Das's avatar
    BIswajit_Das
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    Hello 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], ", ")
    )
     
    • kinitundi's avatar
      kinitundi
      Frequent Visitor
      3 years ago

      Thank you very much, it helped me