Forum Discussion

lovishsood1's avatar
lovishsood1
Icon for Resolver I rankResolver I
2 years ago
Solved

Transformation of table

Hi Everyone,   This should be my end output: But the Problem is My data is coming out of 100% and Above Output is showing DATA according to Total Hours for that month.   I hope I'm able to...
Dataflow
Need Help
Show and Tell
Tips and Tricks
  • pmreis's avatar
    pmreis
    2 years ago

    Hi lovishsood1 

    1) Pivot the Category Column, and Select the Actual_Hrs as the Values

    2) Add a Total Column

    3) Add Custom Columns to calculate the shares

     

    Please find here the solution PBIx, check the Power Query for the solution. 

     


    Pedro Reis - Data Platform MVP / MCT
    Making Power BI and Fabric Simple

    If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

    Find me at LinkedIn
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523