Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
i have two tables
Table 1 is about the allowances assign to specific designation
Table 2 in emplyee payroll table
i want to create a column with specific allowances and amount having allowance name header so that if in future any employee gets difference allowance i can only update my Table 1 and after creation of column in Table 2 the amount goes for the designation wise employees.
Hi,
You can use append queries on the basis of EmpID.
Hi @Naushad123 ,
I am not clear about your requirement, it seems that you want to update amount in table 2, right? I want to know which amount did you want to show for "Managing Director"?
If possible, could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.
Please do mask sensitive data before uploading(you could typing the data or upload by OneDrive for Business ).
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @dax, yes it is like that.i am sorry i double the table2, the first table1 with name desigallow, i want to update the amount specificaly for managing director like you said but in "Orderly Allow" column only, likewise Naib Qasid "integrated Allow" column have value of 450.
Table 1 Allowances record become column in Table2, and update with the amount mentioned in Table1, the criteria in Table 2 is Designation Column,
i hope i tried my best to make you understand.
Hi it's not clear to me what you'r after. Please check this article on how to improve qualilty of your question: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
You've posted 2 (1.5) Tables with the name Table2, that doesn't help understanding.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.