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

vanessafvg 
Thanks for your help, however it is not working and not shoiwng correct result.

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

as i said it needs tweaking.  however agree providing more information might be useful as the in expected result for each row.