Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
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.
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.
Perfect, thank you!
Hi,
Try something like this:
Data (example):
Dax:
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/
Proud to be a Super User!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
53 | |
46 | |
16 | |
12 |