calculation in excel power pivort similar to first/last in power bi

Zhang, Ryan 1 Reputation point

Hi Sir/Madam,

I designed a report via power bi, the raw data is as below.

I sum the 'Qty On Hand' , ‘Qty Available’ etc, and group them by Item number, Please see the report below.
the Description for same Item number is Unique, so in the chart, I use 'first' as calcucation, because I just want to copy the description, all the description for same item is definately the same,no matter the first or the last.
For some reasons, I want to migrate the report to excel using power pivot.
I have migrated the most parts of the report, but after group by Item number, the calucation of description doesn't support 'first' or 'last'
I attempted to put Description in Rows, and adjusted the report layout.
Actually Location, AFL standard PN2 and JET New port No are all field I want just 'copy', all of which have unique value for a same item. but after I did this ,some item number were missing in pivot table.
what can I do to just 'copy' the description to the report.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,523 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Leon Laude 85,686 Reputation points

    Hi @Zhang, Ryan ,

    Please note that Power BI is currently not supported in the Q&A forums, the supported products are listed over here

    You may ask the experts in the dedicated Power BI forum over here:


    If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!

    Best regards,

    0 comments No comments