Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Salesorderdate

    Posted Jan 18, 2022 02:55 AM
    Hello everyone,

    I am new to PowerBI and need your help with the calculation below,

    I have two columns - SalesorderDate and Segment (A and S)

    I need to get the conclusion that If the segment is "A" get the SalesorderDate and if the Segment is "S" make the SalesorderDate same in the segment "A"

    I tried to to this with conditional column but I could not.:(

    Thank you
    have a nice day.

    ------------------------------
    Ebru Cömert
    Marketing Analyst
    +905055321015
    ------------------------------


  • 2.  RE: Salesorderdate

    Posted Jan 20, 2022 03:20 AM
    Hi @Ebru Cömert are you able to provide a sample data just to  understand this better?​

    ------------------------------
    GSC Bolade
    RG2 0FZ
    ------------------------------



  • 3.  RE: Salesorderdate

    Posted Jan 21, 2022 01:58 AM
      |   view attached
    @Sam Casey Bolade

    I attached a sample excel data.

    Thank youuuuu

    ------------------------------
    Ebru Cömert
    Marketing Analyst
    9.05E+11
    ------------------------------

    Attachment(s)

    xlsx
    data.xlsx   11 KB 1 version


  • 4.  RE: Salesorderdate

    Posted Jan 26, 2022 04:40 PM

    Try calculated column

    New SalesOrderDate = LOOKUPVALUE([SalesOrderDate],   [Segment],   "A"  )



    ------------------------------
    Adam Artur Boltryk
    Business Analyst
    ------------------------------



  • 5.  RE: Salesorderdate

    Posted Feb 04, 2022 08:17 PM

    @Ebru Cömert You need to use a lookupvalue for both invoiceaccount and Segment but the issue we have here is that the data needs sorting out as we have duplicate value for where invoiceaccount is 10601218 and Segment is A. For this case, you have 2 answers that the function does not agree with. So to make this work only 1 instance of  invoiceaccount = 10601218 and Segment = A need to be in the table.

    When the data is sorted the formula to use is

    New column = LOOKUPVALUE(data[SALESORDERDATE],data[INVOICEACCOUNT],data[INVOICEACCOUNT],data[SEGMENT],"A")




    ​​

    Hope this is helpful.



    ------------------------------
    Sam Casey Bolade ]
    ------------------------------