Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Most efficient way to create reference tables from original table

Hi there,   I have a primary table in my PowerBI model, and want to perform several transformations to add custom columns.     For example, my primary table contains a unique Customer ID per row,...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi Anonymous 

     

    That's why I asked you to share sample data...Your previous sample is incomplete.

    Try this:

    Last Booking Date =
MAXX (
    FILTER (
        ALL ( table ),
        [Parent Cust ID] = SELECTEDVALUE ( table[Parent Cust ID] )
    ),
    [Booking Date]
)

      

    Best Regards,

    Community Support Team _Janey

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi v-janeyg-msft ,

 

Sorry, I'm not sure I understand.  The column you've highlghted in this sample table is the expected result.

 

Both rows have the same Parent Cust ID, but differing Cust Last Booked Date.  The Parent Last Booking Date is displaying the MAX Cust Last Booking Date across all child entities.

 

Naturally, this value will be repeated or all rows with the same Parent Cust ID, but this is not a problem.

 

Hope that clarifies?

 

C

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Anonymous  So you have no questions, do you?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Erm, not sure I understand.

       

      I do have a question...as described...

       

      "Ok, so next problem (sorry!).  I actually need to expose the MAX(Last Booking Date) across all Customer entities associated with the Parent Customer.  If I create a measure using Last Booking Date = MAX ( Table[Booking Date] ) then I get the Last Booking Date for the individual Customer in my report - which is at Customer Level."

       

      That table was jsut an example of the Parent Cust Last Booking Date column I'm hoping to create.

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        Anonymous  

         

        If you only want to display the max date.

        You can try:

        Last Booking Date =
MAXX ( ALL ( table ), [Booking Date] )

         

        Best Regards,

        Community Support Team _Janey

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.