Forum Discussion

SofiaTeles's avatar
SofiaTeles
Frequent Visitor
3 years ago

Calculated column displaying the first and last value/text shown in another column.

Hi,    Please consider this sample purchases dataset:    Client Purchase Date Order code Promocode A 14/04/2023 A001 code40 B 15/04/2023 A002 code50 C 16/04/2023 A003   ...
Need Help
SofiaTeles's avatar
SofiaTeles
Frequent Visitor
3 years ago

Hi DOLEARY85 

 

Thank you so much for your quick reply.

 

Power Bi is returning this error: "A multi-value table was provided where a single value was expected."

 

Do you know how can I solve it? I might have simplified the dataset presented here compared to the one I'm using.

 

Thanks in advance...

 

Best regards, 

Sofia

  • DOLEARY85's avatar
    DOLEARY85
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Hi,

     

    i don't suppose you can share the PBIX file?

    • SofiaTeles's avatar
      SofiaTeles
      Frequent Visitor
      3 years ago

      Yes, I cannot...

      • DOLEARY85's avatar
        DOLEARY85
        Icon for Resident Rockstar rankResident Rockstar
        3 years ago

        I'd assume the issues was based on duplicates on the join in the table, however i tried duplicating a row in my test table and it's still working.

         

        Do you have an anonymised data set i could look at?