Continous Date  [Solved]

Anything related to PowerPivot and DAX Formuale
jrpol
Posts: 2
Joined: Wed Jul 11, 2018 9:09 pm

Continous Date

Postby jrpol » Wed Jul 11, 2018 9:27 pm

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 24 times


Many thanks in advance.

MattAllington
Posts: 983
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Continous Date  [Solved]

Postby MattAllington » Thu Jul 12, 2018 7:27 am

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
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

jrpol
Posts: 2
Joined: Wed Jul 11, 2018 9:09 pm

Re: Continous Date

Postby jrpol » Sun Jul 15, 2018 4:44 pm

Thanks a lot!!!


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: MattAllington and 6 guests