Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |