Share via

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

Zhang, Ryan 1 Reputation point
2021-08-24T03:26:02.643+00:00

Hi Sir/Madam,

I designed a report via power bi, the raw data is as below.
125800-image.png

I sum the 'Qty On Hand' , ‘Qty Available’ etc, and group them by Item number, Please see the report below.
125871-image.png
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.
125812-image.png
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'
125845-image.png
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.
125853-image.png
what can I do to just 'copy' the description to the report.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,798 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Leon Laude 85,726 Reputation points
    2021-08-24T06:06:34.06+00:00

    Hi @Zhang, Ryan ,

    Please note that Power BI is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products.

    You may ask the experts in the dedicated Power BI forum over here:
    https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

    ----------

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

    Best regards,
    Leon

    0 comments