Forum Discussion

PijushRoy's avatar
PijushRoy
Community 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
Community 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
Community 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

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    3 years ago

    Hi rsbin 

    I need to solve this urgently, I am also trying. Can you please try and let me kwon, It will great help for me.