Forum Discussion

ABC11's avatar
ABC11
Icon for Resolver I rankResolver I
4 years ago
Solved

Row value in column -power bi

Hi All, I have source data look like this. VENDOR_NAME LASTNAME FIRSTNAME PERSONID LABORHRS SITEID LABORLINECOST ABD LTD ADAMS FARAH 3000 800 HOR 12000 ABD LTD AHMED DAVID 3...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi ABC11 ,

    I'm not clear about your final expected result. Do you want to create a report in Power BI? If yes, you can refer the following documentations to get it:

    Connect to SQL Server

    Refresh data from an on-premises SQL Server database

    1. Connect to SQL Server database and put your SQL query into SQL statement textbox under Advanced options tab just as below screenshot...

    2. Transform the data in Power Query Editor

    3. Create visualizations

    4.  Publish report to Power BI Service

    As for how to get % and ratio, you can get them by creating measures, calculated columns, etc. Before that you may need to provide the corresponding calculation logic so that we can provide you with a suitable solution later.

    Percentage= DIVIDE(SUM('Table'[HOR_LABORHRS]),SUM('Table'[ALB_LABORHRS]))

    Best Regards

ABC11's avatar
ABC11
Icon for Resolver I rankResolver I
4 years ago

ok. Thanks

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ABC11 ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

Otherwise, please provide the requried info in my previous post. We will provide you a suitable solution later.

Best Regards