Page 1 of 1

Continous Date

Posted: Wed Jul 11, 2018 9:27 pm
by jrpol
Hi All!

I am not sure if this is possible with DAX.
I need to identify the invoice number per specific Client ID (if there is any) which is "continous" meaning the end date of the previous invoice number is the same with the start date of the succeding invoice.

attached is the desired out put (Status column).

sample.xlsx
(360.24 KiB) Downloaded 13 times


Many thanks in advance.

Re: Continous Date  [Solved]

Posted: Thu Jul 12, 2018 7:27 am
by MattAllington
You can probably do it in DAX, but how about you take a look at my video showing how you could do this in Power Query. https://www.youtube.com/watch?v=xN2IRXQ2CvI

Re: Continous Date

Posted: Sun Jul 15, 2018 4:44 pm
by jrpol
Thanks a lot!!!