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] )
    )

     

     

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

PijushRoy  you haven't provided more information

 

i haven't done all of it but is this what you are looking for?  please confirm - you haven't give enough information, you havent provided an expected solultion.  If you need help you do need to provide a clear set of what is expected.

 

 

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

vanessafvg 
Can you please share the pbix, when I applied calcualtion, I am not getting same data as you mentioned in image.