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
pmreis's avatar
pmreis
Icon for Most Valuable Professional rankMost Valuable Professional
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