Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.