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.
Hello Expert,
I'm newbie to power query and PBI as trying to find solution for my requirement and afraid as i couldn't find it.
Here is input
Firstly, it should create duplicate row referring the upper row and Duplicate row should calcuclate by adding D+G columns of Input.
Ex for 1 - in column D as 16 and G as 8 = 24 should appear in new dulicate line item.
Appreciate your valuable inputs in this regard.
Regards,
Arjun
Solved! Go to Solution.
@Anonymous
Please see attached file as well
HI Arjun @Anonymous
You can also do it via DAX calculated TABLE
Go to Modelling Tab>> NEW TABLE
Table = VAR temp = SELECTCOLUMNS ( table1, "A", [A], "B", [B], "C", [C], "D", [D], "E", [E], "F", [D] + [G], "G", [F] + [I], "I", [I] ) RETURN UNION ( Table1, temp )
@Anonymous
Please see attached file as well
Thank you @Zubair_Muhammad,
How can I use this function by importing the file from other workbook, which calaculation do i need to select?
Regards,
Arjun
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.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |