Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello!
I have the following table (It's just one table. I screenshoted in different places) that I want to summarize based on the last value of two columns (Real and Target), producing other two columns in the new table with these new values.
Until now, I was only able to get the last value from the real column.
SUMMARY =
SUMMARIZE(Append1, Append1[NAME], "Real", LASTNONBLANKVALUE(Append1[Week], SUM(Append1[Real])))
However, I also need to get the last value from the "Target" column, also based on the last value of the "Real" column.
So we would get something like this
NAME | Real | Target |
FER | 510 | 945 |
MON | 689 | 530 |
Transferência de Peças | 400 | 715 |
As you see above, the last update was made in W34 for "FER" and "MON" and in W36 for "Transferência de Peças".
Any idea on how to get the result above?
Thank you in advance
Solved! Go to Solution.
Hello,
this did the trick:
Hello,
this did the trick:
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
21 | |
20 | |
19 | |
13 | |
12 |
User | Count |
---|---|
41 | |
27 | |
23 | |
22 | |
22 |