Forum Discussion

Pbilearner02's avatar
Pbilearner02
Frequent Visitor
3 years ago
Solved

Developing report

Hi all,

I am a new bee to Power BI and trying to learn while trying to do a report. I have a report as table1.  I had clean the data like two sep table - table 2 and 3.  Finally append them as Table 4.  But now I need the subtotal per week ending

 

Table 1:                  
Name TitleManagerPillarWeek endingAdminstrativeAdmin sub categoryAd MonAd TueAd Wed Ad ThurAd FriDP supportDP support sub categoryDP MonDp TueDp Wed Dp ThurDP Fri
AAAADBAljdlsjdxyz11/11/2022administrativemeeting12 1 DP supporttraining4 211.5
AAAADBAljdlsjdxyz11/8/2022administrativefiling0.5 11.50DP supporttraining2.521  
                   
Table 2:                  
Name TitleManagerPillarWeek endingCategorysub categoryMon Tue Wed  Thur Fri       
AAAADBAljdlsjdxyz11/11/2022administrativemeeting12 1        
AAAADBAljdlsjdxyz11/8/2022administrativefiling0.5 11.50       
                   
Table 3:                  
Name TitleManagerPillarWeek endingCategorysub categoryMon Tue Wed  Thur Fri       
AAAADBAljdlsjdxyz11/11/2022DP supporttraining4 211.5       
AAAADBAljdlsjdxyz11/8/2022DP supporttraining2.521         
                   
Table 4:                  
Name TitleManagerPillarWeek endingCategorysub categoryMon Tue Wed  Thur Fri       
AAAADBAljdlsjdxyz11/11/2022administrativemeeting12 1        
AAAADBAljdlsjdxyz11/8/2022administrativefiling0.5 11.50       
AAAADBAljdlsjdxyz11/11/2022DP supporttraining4 211.5       
AAAADBAljdlsjdxyz11/8/2022DP supporttraining2.521         



Need Help
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi Pbilearner02 

    please try this, select the columns then click Standard - Add

    result

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • serpiva64's avatar
    serpiva64
    Solution Sage
    3 years ago

    Hi,

    to do what you want you need to create a new column by selecting your column and adding them 

    If this post is useful to help you to solve your issue consider giving the post a thumbs up 

     and accepting it as a solution !

     

    • Pbilearner02's avatar
      Pbilearner02
      Frequent Visitor
      3 years ago

      Hi Serpiva

      can I do it according to the week ending?  If I am collaborating it,  in report developer how can I do total hours per week.

      thank you serpiva for all the help.

       

       

      • serpiva64's avatar
        serpiva64
        Solution Sage
        3 years ago

        Hi,

        can you post an exemple of your desired result