DateDiff between rows of Status changes

Hi Greg_Deckler ,

Thank you for your prompt reply to my inquiry.  I've read through your article and think it is a brilliant algorithm for calculating concurrent timestamps for calculating MTBF.  I tried adjusting the code to fit my scenario, but unfortunately come across an ERROR when I attempt to create the new column with the VAR Next code.  Apologies for my naivete with regard to PwrQuery and DAX.

I get these errors any time I try to use code with a variable declaration in the beginning, is there something I am doing wrong or misunderstanding with regard to DAX functionality.

StsTimeDiff = 

VAR next = MINX(FILTER(MASTER3_FIELDHISTORY,

                       MASTER3_FIELDHISTORY[mrID]=EARLIER(MASTER3_FIELDHISTORY[mrID]) &&

                       MASTER3_FIELDHISTORY[mrTIMESTAMP]>EARLIER(MASTER3_FIELDHISTORY[mrTIMESTAMP])

               ),MASTER3_FIELDHISTORY[mrTIMESTAMP])

RETURN IF(ISBLANK(next),

               DATEDIFF([mrTIMESTAMP],NOW(),MINUTE),

               DATEDIFF([mrTIMESTAMP],next,MINUTE)

           )

Error: Token Eof expected.

Show error highlights the VAR next segment at the top.

Steps I took, for reference:

1. Go to Power Query tab
2. Entered Power Query table/query editor
3. Select Add Column tab
4. Select Custom Column button
5. Name the column, "StsTimeDiff"
6. Paste code starting at VAR
7. Receive the Token Eof Expected error, can't click okay.

Sincerely,

Kristopher

Apologies for my lack of understanding, Greg_Deckler ,

Someone from another post clarified the difference between M-Code and DAX.  I will need to verify this works in Power Pivot with DAX, or otherwise see if a solution in M-Code is obtainable.

I will reach back out to confirm once I have secured a solution to confirm.  

Sincerely,

Kristopher