Forum Discussion

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
3 years ago
Solved

Two DAX calculated column needed for calculate returning customer series and no of invoice

Hi Team, I have data like below (from column 1 to 3) and I need to create two calculated column for 4 and column 5 PBIX file attached for sample data and two require column   Thanks in...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi PijushRoy ,

     

    Redo the calculation to:

    CUST SERIES = 
VAR MAXINVOICE =
    IF ( Data[Hown Many Invoices] = 1, Data[Index],Data[Index]+ Data[Hown Many Invoices]-1 )
RETURN
    IF (
        Data[Hown Many Invoices] <> BLANK (),
        Data[Invoice_ID] & "-"
            & MAXX ( FILTER ( ALL ( Data ), Data[Index] = MAXINVOICE ), Data[Invoice_ID] )
    )

     

     

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
3 years ago

Hi,

Any help please

  • rsbin's avatar
    rsbin
    Icon for Community Champion rankCommunity Champion
    3 years ago

    PijushRoy ,

    Please refer to modified pbix attached.

    Edit: 

    Just realized I didn't follow through with all your requirements.  Hoping though you can see the pattern and make the necessary modifications.

    Trust you will be able to follow the logic.

    Any questions, please ask.

    Best Regards,

    • PijushRoy's avatar
      PijushRoy
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Hi rsbin 

      Thanks for your help, but it is not working
      Series ending value is not matching
      Invoice count number is not correct for all

      • rsbin's avatar
        rsbin
        Icon for Community Champion rankCommunity Champion
        3 years ago

        PijushRoy ,

         I thought the logic of capturing the first 3 characters would work, but unfortunately

         this appears not to be the case.

        Looks like another approach or method will be required.

        Might be worthwhile closing this thread and start a new one.

        Revised file attached.  Gets a little closer but still instances where logic is incomplete