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 MFelix 
Small mismatch
It is taking Index 4 rows Invoice number inplace of Index 25 Invoice no

MFelix's avatar
MFelix
Super User
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] )
    )