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,
I am having trouble displaying the same quantity in column G when displaying the "latest" date from column A. It can only show me the sum of column G.
In the screenshot below you can see that it shows me the latest posting date of this SKU correctly, but as quantity it shows me the sum of column G. I would only like to display the value from column G in the same row as it took the posting date from column A.
A | B | C | D | E | F | G | H | I |
2022-11-11 | Purchase | 105020 | 10029-3 | SLS BMG Hinge Righthand | L1304 | -8 | -128 | 0 |
2022-11-11 | Purchase | IB100863 | 10029-3 | SLS BMG Hinge Righthand | L1304 | 500 | 0 | 8012,63 |
2022-09-29 | Purchase | IB100644 | 10029-3 | SLS BMG Hinge Righthand | L1304 | 300 | 0 | 5280 |
2022-08-29 | Purchase | 105007 | 10029-3 | SLS BMG Hinge Righthand | L1304 | -3 | -54 | 0 |
2022-08-29 | Purchase | IB100446 | 10029-3 | SLS BMG Hinge Righthand | L1304 | 100 | 0 | 1799,44 |
2022-08-12 | Purchase | IB100370 | 10029-3 | SLS BMG Hinge Righthand | L1304 | 500 | 0 | 8929,05 |
2022-07-07 | Purchase | 105002 | 10029-3 | SLS BMG Hinge Righthand | L1304 | -4 | 0 | -71,39 |
2022-06-07 | Purchase | IB100012 | 10029-3 | SLS BMG Hinge Righthand | L1304 | 500 | 0 | 8012,64 |
2022-06-01 | Purchase | IB100004 | 10029-3 | SLS BMG Hinge Righthand | L1304 | 315 | 0 | 5621,98 |
Solved! Go to Solution.
@Bondeuz , same if these can help
Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.
@Bondeuz , same if these can help
Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |