Continous Date  [Solved]

Anything related to PowerPivot and DAX Formuale
Posts: 5
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).

(360.24 KiB) Downloaded 53 times

Many thanks in advance.

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

Posts: 5
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: No registered users and 2 guests