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 guys,
I have the next table in Power BI:
I want to create a new table removing duplicates in the column 'IDEXPEDIENTE' with the next characteristics:
Column 'FECHAFACTURA'. Put the last date of the duplicates values
Column 'TOTALBRUTO'. Calculate the sum of 'TOTALBRUTO' values that have the same 'IDEXPEDIENTE'
Column 'TIPOIVA'. Put the number of the last date
Column 'CUOTAIVA'. Calculate the sum of 'CUOTAIVA' values that have the same 'IDEXPEDIENTE'
Column 'TOTALFACTURA'. Calculate the sum of 'TOTALFACTURA' values that have the same 'IDEXPEDIENTE'
Column 'IDFACTURACION'. Put the value of the last date
I should obtain a table similar to the next one:
Thanks in advance.
Regards.
Solved! Go to Solution.
Hello @PwrBI01
Assuming your table name is "Table", try below dax to create new table.
1). Dax method
Go to Table tool and create DAX table, and use below DAX
2).
In PowerQuery you can create this easily using Group BY.
Please let me know if this solves and this is what you were looking for.
Hello @PwrBI01
Assuming your table name is "Table", try below dax to create new table.
1). Dax method
Go to Table tool and create DAX table, and use below DAX
2).
In PowerQuery you can create this easily using Group BY.
Please let me know if this solves and this is what you were looking for.
Thank you very much, option 1 is just what I need.
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |