Forum Discussion
Community ChampionTwo DAX calculated column needed for calculate returning customer series and no of invoice
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] ) )
Community ChampionPlease 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,
Community ChampionHi 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
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