Please Help me if you can.

[VitorNotaro34]

Hello good morning all.

I am quiet new with Power BI, and at the moment I am trying to do some pratices converting old Excel Formuls to DAX or M.

I have the below situation with a mixed formule in XL, is just multipe condicoes to generete a new column, its basicaly IF+AND (If assembler is the same, (If date is the same,(Calculate the Gap for the next Picking), If the GAP result is smaller than 5 hours bring me the result, if NOT retunr a 00:00:00)

The question is, based in your exeperience , is it possible to biuld it with DAX and avoid to creat this column on the model ?

If Yes wich formules do I need ? Does anybody can help me to do it please ?

If is not possible to do in DAX How to do it in M ? I already know I would need to creat a function ( )=> but I am not getting progress.  Someone Can help me please ?

Thanks in advanced.

[lbendlin]

You actually have bigger problems than that. Fetching data from the "previous" row is non-trivial in DAX. You need to have a guaranteed sort order for that. Can  the combination of A,B and C serve as that sort key? Or better yet, can you add an index column?

[VitorNotaro34]

Hi Man.

First of all thanks very much for reply, I really apreciate that.

About Sort the columns I dont think so is a problem cause I can creat a step into Power Querry to sort by Assembler,Date and Time, this would garrantee the correct sequence always.

Yes for sure would be possible Add a index Column but how this could help me ?

Thanks in Advance 

What is the plan for that ?