topic First Time Fix in DAX Commands and Tips

First Time Fix

Anonymous — Mon, 08 Aug 2022 09:31:07 GMT

Hello,

Could someone help me with a custom column for First time Fix please?

I have 2x date columns and im looking to find out if the job was completed as a first time fix.

Start Date

Finish Date

First Time Fix - Yes/No

Thanks,

ValtteriN — Mon, 08 Aug 2022 10:30:01 GMT

Hi,

Try something like this:

Data (example):

Dax:

Column = MAXX(filter(FixExample,and('FixExample'[First Time Fix]="Yes",earlier(FixExample[ID])=[id])),'FixExample'[finish date])

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Anonymous — Mon, 08 Aug 2022 13:20:38 GMT

No sorry, i dont think i have explained myself very clear.

I'm looking to add the column for Yes and No. I have a start date and finish date.

Basically i need a measure for = IF "Created Date" is the same as "Fix Date" then Yes, else No.

cmarrazzo — Mon, 08 Aug 2022 17:03:36 GMT

Open the Power Query Editor, and click on the Add Column tab. Select Conditional Column.

When the dialogue box opens, fill out new column name box and fill out the form:

Column Name = start date

operator = equals

value = change to Select a Column and select finish date

output = Yes

Else = No

This should get you there.

Anonymous — Tue, 09 Aug 2022 07:07:21 GMT

Perfect, thank you!